$ mysql -u root -p mysql Grant access to a new database # service mysql-server restart Step # 5 Grant access to remote IP address # /usr/local/etc/rc.d/mysql-server restart If you are using FreeBSD, type the following command to restart the mysql server: If you are using RHEL / CentOS / Fedora / Scientific Linux, type the following command to restart the mysql server: If you are using Debian / Ubuntu Linux, type the following command to restart the mysql server: Since you need to allow remote connection this line should be removed from my.cnf or put it in comment state. This option is highly recommended for systems where only local requests are allowed. All interaction with mysqld must be made via Unix sockets. skip-networking : Do not listen for TCP/IP connections at all.Make sure line skip-networking is commented (or remove line) and add following line bind-address=YOUR-SERVER-IPįor example, if your MySQL server IP is 65.55.55.2 then entire block should be look like as follows: # vi /etc/my.cnf Step # 3: Once file opened, locate line that read as follows If you are using FreeBSD you need to create a file /var/db/mysql/my.cnf location.If you are using Red Hat Linux/Fedora/Centos Linux file is located at /etc/my.cnf location.If you are using Debian/Ubuntu Linux file is located at /etc/mysql/my.cnf location.Once connected you need to edit the MySQL server configuration file my.cnf using a text editor such as vi:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |