Hot answers tagged mysql
Why can't you try installing the MySQL using its MSI installer, which is much user friendly - where you can have a installation wizard with nice on-screen instruction, where you can simply install it by following the simple 1,2,3 steps ..
The program mysqladmin is not an interactive client. It is a client-based utility. mysqladmin allows you run connect to mysqld, run a single command from a specific set of commands, and then, disconnect. EXAMPLE #1 Some commands that can be done in the mysql client can be done in mysqladmin. mysqladmin -uroot -ppassword flush-hosts mysqladmin -uroot ...
The archive is a compressed version of the MySQL directory structure. When you extract this archive you'll find that it creates a directory called mysql-5.6.22-win32 inside whichever directory you told it to extract to. If the ZIP file is downloaded to C:\Users\your_user_name\Downloads and you were to extract the archive into that directory, then a ...
Have you installed phpmyadmin? Seems to me like you missed it. It's not a part of the LAMP stack per se, but an administration tool for configuring MySQL (which is written in php). You would need to do sudo apt-get install phpmyadmin as per this guide. After completing this step, you should be able to access phpMyAdmin. Hope this helps ;)
So you are basically saying that when you connect via IP address to the Ubuntu MySQL you can connect, but when you are on localhost you can’t correct? This could be an issue with MySQL grants being tied to the IP address. But unclear. I would do the following to debug. First, the basics. Before anything, you say you have php5 and php5-mcrypt installed. ...
Reference Running a server with binary logging enabled makes performance slightly slower. However, the benefits of the binary log in enabling you to set up replication and for restore operations generally outweigh this minor performance decrement.
To run the MySQL in the command prompt,please follow the steps (i) Open the command prompt and use the command cd C:\Program Files\MySQL\MySQL Server 5.6\bin. (ii) Now run the exe mysqld.exe. You would be able to connect the mysql.
This issue might be caused due to several issue. You can find the exact error from "tail /var/log/mysql/error.log". I have added the default fix for these kind of issues. If the below is not working then update us the print from log where we can try to get some info and move further Kill all the MySQL process using the following command. ps aux | grep ...
The SQL data connector in Excel is for connecting to Microsoft's SQL server. To connect to MySQL you'll need to install a specific connector for MySQL. You can get a MySQL ODBC connector from Oracle here. ODBC Driver for MySQL (Connector/ODBC) Also, Oracle makes a utility called MySQL for Excel which should get you everything you need to hook up ...
Only top voted, non community-wiki answers of a minimum length are eligible