Linux – Changing startup parameters for MySQL

centoslinuxMySQL

I need to remove skip-networking from MySQL startup parameters

I am running MySQL on Linux on Centos on a VPS

Can someone please tell a newbie how to do this ?

I suppose to start and stop the mySQL server, I have to do something like this
/etc/init.d/mysqld stop
/etc/init.d/mysqld start

# ps -ef|grep 'mysql'  
root     11331 20220  0 10:53 pts/0    00:00:00 grep mysql  
root     32452     1  0 Apr02 ?        00:00:00 /bin/sh /usr/bin/mysqld_safe --skip-grant-tables --skip-networking  
mysql    32504 32452  0 Apr02 ?        00:00:18 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-external-locking --socket=/var/lib/mysql/mysql.sock --skip-grant-tables --skip-networking

Best Answer

Open up the /etc/init.d/mysqld script, find the --skip-networking parameter and remove it.

Related Topic