Changing startup parameters for MySQL
- by RN
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
