Getting the MySQL Daemon Ready for Connections

GNU Boot Loader This procedure is for Linux greenies like me who can’t control the post-grub startup procedure—and we definitely cannot figure out how to get around not having a static IP address. “Adding a startup script to be run at bootup” may prove to be useful but in the mean time:

Use ifconfig to find out the current IP Address of DHCP.
Enter this IP address for bind-address in my.cnf.
``Run the MySQL Daemon: sudo mysqld &
Verify that it is alive: mysqladmin -u root -p ping
Verify that it is alive again: mysqladmin -u root -p ``version

Comments

AG, 2006-09-29 00:49:29

I generally run 'mysql daemon' in safe mode. Actually, this is generally the recommended method for running mysqld 'mysqld_safe'.. Offers automatic restart of the server, should it be interrupted. There are other benefits as well.

rasx(), 2006-09-29 04:43:10

I tried this:

sudo /usr/bin/mysqld_safe

and I got this:

Starting mysqld daemon with databases from /var/lib/mysql mysqld_safe[3827]: started STOPPING server from pid file /var/run/mysqld/mysqld.pid mysqld_safe[3840]: ended

It looks like it started and then stopped. Later study revealed that this is yet another script for MySQL:

sudo /etc/init.d/mysql start

rasx()