LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Server (https://www.linuxquestions.org/questions/linux-server-73/)
-   -   mysql problem (https://www.linuxquestions.org/questions/linux-server-73/mysql-problem-476299/)

aviper 08-22-2006 01:05 PM

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 ?

ph34r3d 09-28-2006 05:04 AM

what do you logs say for mysql?

post a snippet if you can

trickykid 09-29-2006 12:40 AM

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.

aviper 09-29-2006 01:45 AM

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.