Getting Started with Mysql and Heidi SQL

Getting Started with Mysql and Heidi SQL

At the target server prompt, become root and type:

apt-get install mysql-server

provide a a password for the root mysql user

Verify that mysql is running:

netstat -tap | grep mysql

you should see something like this:

tcp 0 0 localhost:mysql *:* LISTEN 21921/mysqld

Verify that you can log in:

mysql -u root -p

 

You should be prompted for the root password and your prompt should change to:

mysql>

Type “help” or “?” to review the commands.

Type to exit:

q

To configure Mysql for remote connections edit /etc/mysql/my.cnf

Verify the port number. The default is 3306
Set the bind-address to 0.0.0.0

Log in to mysql as above and execute the following commands.

CREATE USER ‘myuser’@’localhost’ IDENTIFIED BY ‘mypass’;
CREATE USER ‘myuser’@’%’ IDENTIFIED BY ‘mypass’;

GRANT ALL ON *.* TO ‘myuser’@’localhost’;
GRANT ALL ON *.* TO ‘myuser’@’%’;

Note: the ‘localhost’ and ‘%’ are the correct syntax. Only change myuser and mypass.

q

Restart mysql:

/etc/init.d/mysql restart

You should be able to install Heidi SQL and log in now.

Matt
01/23/2015