I agree. Mysqld is a daemon and should be running in the background.

What distro do you use? Use ckconfig to enable services for the proper run levels for RPM distros like Redhat. You may also have a GUI config program where yiu can do it as well.

Undo what you did for the guest user. Giving "guest" root rights without a password sound like a horror story sys admins tell be the campfire.

Also download the manual for mysql. It lists tasks you need to perform after installation, such as giving the mysql root user a password, and dropping the demo tables.

try it

#sudo mysqld

edit the file inside as

% guest ALL=(ALL) NOPASSWD: (ALL)

then restart the mysqld.

sudo /etc/init.d/mysqld restart

no need to stop and start the mysqld just restart it.

Hi,
Thanks for your guidance. I would check it on Monday.
Zulfi.

Hi,
I am still trying.

Zulfi.

Hi,
Thanks all of you who helped me with this problem. Its working. I tried on several computers but not on all. However, on RedHAt based computers i am getting some problem with service command. I have to check this again and let you people know if there is any problem. Otherwise I would declare this thread as solved.

Zulfi.

or This will enable mysqld for run levels 3 and 5. Check the man page to see which will work. You may also need to use mysqld as the name instead. chkconfig is a wrapper around insserv so different distros may be slightly different. Newer distros may use systemd but still support starting services the old way.

Please stop trying to give "guest" users root access with sudo. The idea is inane and very dangerous.