SlackwareThis Forum is for the discussion of Slackware Linux.
Notices
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Get a virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month. Click here for more info.
first of all ii'm guesing you installed slackware and enabled mysql server.
what needs to be done after that is to run $>mysql_install_db from the prompt
this will create the required user databases and put them in the right places.
after that you need to edit the /etc/rc.d/rc.mysqld file and look for the command that runs mysqld and add --user=root to it.
it won't allow the mysql server to start unless a valid user is starting it. root always works and if you create other administrators they can also start up the server.
cyberhawk, it's not good to run mysql daemon with root privileges. That's why there's a user called mysql and the daemon defaults to run with it.
If you read the instructions on /etc/rc.d/rc.mysqld it will instruct you on how to create the databases with the correct privlege (owned by mysql user).
Originally posted by gbonvehi Did you created the databases as stated in /etc/rc.d/rc.mysqld ?
Nope, I could not.
I am not able to enter into the environment.
/etc/rc.d/rc.mysqld also gives the same error, so I am not able to enter into mysql to make any database.
Just reinstalled Slackware but strange...........a complete reinstall also giving the same problem.
Originally posted by cyberhawk first of all ii'm guesing you installed slackware and enabled mysql server.
what needs to be done after that is to run $>mysql_install_db from the prompt
this will create the required user databases and put them in the right places.
after that you need to edit the /etc/rc.d/rc.mysqld file and look for the command that runs mysqld and add --user=root to it.
it won't allow the mysql server to start unless a valid user is starting it. root always works and if you create other administrators they can also start up the server.
hope this helps
The problem is that I am not able to enable mysql server.
/etc/rc.d/rc.mysqld is producing an error which is same as my thread and quitting.
Go back and read the MySQL manual (for your convience, it is located here: http://dev.mysql.com/doc/mysql/en/index.html ) or, as gbonvehi suggested, read the contents of /etc/rc.d/rc.mysqld (~$ less /etc/rc.d/rc.mysqld).
To paraphrase:
You must run a script *BEFORE* starting MySQL for the first time to instantiate some fixed databases (the mysql database itself, for example).
Once that script has been run (and run correctly), then AND ONLY THEN, will you be able to type: ~$ /etc/rc.d/rc.mysqld start
Please read the documentation provided with MySQL, all the information is in there.
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.