How to connect MySQL installed on Windows 7 machine

Started by certforumz, January 12, 2013, 03:05:19 AM

Previous topic - Next topic

certforumz

http://forums.techguy.org/software-development/623379-solved-how-enable-remote-access.html

Here's the steps to do that (on the server computer):

1. Open a DOS command prompt on the server.
2. Run the following command from the mysql\bin directory:
mysql -u root --password=
3. A mysql> prompt should be displayed.
4. To create a remote user account with root privileges, run the following commands:
GRANT ALL PRIVILEGES ON *.* TO 'USERNAME'@'IP' IDENTIFIED BY 'PASSWORD';

'USERNAME' is the username to be created.
'IP' is the public IP address of the remote connection.
'PASSWORD' is the password to be assigned for this username.
(IP can be replaced with % to allow this user to logon from any host or IP)

mysql> FLUSH PRIVILEGES;
mysql> exit;

Oh, I got it. It's due to my Windows Firewall. Just turn off it (unsecured) or add MySQL port (e.g. 3306) to the WFirewal's exception.