Posted By: Anonymous
I have installed MySQL Community Edition 5.5 on my local machine and I want to allow remote connections so that I can connect from external source.
How can I do that?
That is allowed by default on MySQL.
What is disabled by default is remote
root access. If you want to enable that, run this SQL command locally:
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION; FLUSH PRIVILEGES;
And then find the following line and comment it out in your
my.cnf file, which usually lives on
/etc/mysql/my.cnf on Unix/OSX systems. In some cases the location for the file is /etc/mysql/mysql.conf.d/mysqld.cnf).
If it’s a Windows system, you can find it in the MySQL installation directory, usually something like
C:Program FilesMySQLMySQL Server 5.5 and the filename will be
bind-address = 127.0.0.1
#bind-address = 127.0.0.1