mysql problem
Hello,
I want to access my mysql server remote, I found that by default --skip-networking is on. So I deceide to remove it after that mysql doesn't want to start. I've run those 2 command: (1) /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/run/mysql/mysql.pid & This gives me: Starting mysqld daemon with databases from /var/lib/mysql STOPPING server from pid file /var/run/mysql/mysql.pid 060822 21:24:17 mysqld ended (2) /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/run/mysql/mysql.pid --skip-networking & This works perfect, but only with local connection, no remote connections :/ Any ideas ? |
what do you logs say for mysql?
post a snippet if you can |
Try disabling it in the my.cnf file or the conf file that mysql is using. But in all honesty, this is a good thing to have for security reasons. I'd recommend keeping it on and then manually setting/configuring your remote connections in the mysql database.
|
I resolve the problem.
Slackware uses another place for: --skip-networking /etc/rc.d/rc.mysqld Which was strange for me. |
All times are GMT -5. The time now is 05:15 PM. |