Starting mysql using login script
 

Hi,
Can sombody plz guide me how to start mysql using a login script. I dont want to type pasword.

Zulfi.

can you please elaborate

what operating system your using , the version of mysql etc ...

what do u mean by login script ? what are you trying to achieve?

Hi,
Thanks for your response. I am using Fedora 1o. I want to start sqld and some people on this forum helped me for this. However I have to use :
commands which asks password. That's why I want to create a login script so that no body can see the passwd. Kindly guide me:

i)how to write the script for executing the above commands without providing the passwd. The script should be able to execute at the time of guest user's login.
ii) in which file i have to store the script.

Zulfi.

Is there a specific reason why you don't want the mysql daemon to be started at startup?

Nobody can see the password when you type it ;)

Not possible (to my knowledge) when using 'su'. I guess Fedora has support for 'sudo', so you should be able to set that up so (one or more) users can start the mysql daemon without need for a password.

A last note: your title states mysql (the mysql client), your thread is about mysqld (the mysql daemon). There is a difference between the two ;)

Thanks for the correction of the title.

No. This is what i want. mysqld is not starting at boot time. I have to first login to guest account and then i have to run mysqld. Its a teaching environment. I want to start it after the OS (Fedora) is loaded or after the guest login. Otherwise i have to run mysqld on all PCs and this would allow leakage of passwd.

I want to start mysqld at startup or at guest login and this is what i am looking for.

I dont know about sudo but how can i use it in a login script?

Zulfi.

If it does not matter, let it start when the system boots (you don't need to know the password for that). If that does not work, check why it does not work and fix that. I'm not a fedora man so I can't say what to do to get it automatically started in fedora.

But you have to setup 'sudo', something I have not played with.

Maybe more knowledgeable people can give the finer details.

see http://www.mjmwired.net/resources/mj...es.html#enable
It explain how to set up services in fedora.

There is some graphical utilities where you can enable or disable services by clicking the checkboxes.

or you can allow some users with permission to run specified commands as root by sudo, all you need is to edit /etc/sudoers file using visudo.
eg:-
[user] ALL=(ALL) NOPASSWD: [command]
replace [user] and [command] with appropriate values.
then you can execute:
sudo [command] without any password if logged in as [user].

Also check.
man sudo
man sudoers

Thanks _dkode_ and Wim Sturkenboom. I would try on your advice.

Zulfi.

Hi,
I tried to change the following line in sudoers file:

with
but its giving me error when i tried to save the file. It says:
Kindly guide me.

Zulfi.

use the full path(absolute path) for the command.
if you don't know the path, use 'whereis' to find it.

Assuming you need to run sqld as root.

#whereis sqld
this will give you the path, lets say /usr/sbin/sqld
then you can change your sudoers entry to:
you may need to use mysqld instead of sqld

Hi,

Thanks for your response.

I tried :
but I am getting following error:
The root path for mysqld is:

Kindly guide me with this problem.

Zulfi.

I'm a bit of a noob, so I may be wrong, but I didn't think gz was a type of executable file? Google seems to confirm this.

Also, it would appear that you may have changed your sudoers file to make the sudo command log in as guest, not as root.

@Shammyhealz: Look at the location the the gz-file; it's just the man page for mysqld

You are using: sudo service mysqld start
you need to add the command /sbin/service mysql start, in sudoers.
not mysqld

*edited

in this settup you can run, without password
to execute
without password, you need to add entry
there is also a short cut to allow executing all command as root without password in sudo, I use that in my servers. but it is dangerous if the guest account is accessible to persons other than administrators. if you use it, use with care or do not use.

+1 to that. It is the normal way to start mysqld and is routinely used on many many systems.

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.