Hello.
Probably mysqld_safe uses wrong values for directories. Possible solution is to store the correct paths in configuration file, and if it is situated not in standard location, launch mysqld_safe with --defaults-file=path_to_config_file. Or use command line options for mysqld_safe. Check the error log, it should be in /var/lib/mysql. See: http://dev.mysql.com/doc/mysql/en/program-options.html >Dear there, > >After install mysql 4.1.12 by using rpm, I have some problems to restart >server after >shutting down it. When I use "mysqld_safe" try to restart, it give me >error as follws: > >Starting mysqld daemon with databases from /var/lib/mysql >STOPPING server from pid file /var/run/mysqld/mysqld.pid >050525 18:08:04 mysqld ended > >Then, I notice in /var/run directory, there is no directory called >mysqld. And I also not >familiar with mysqld.pid file. > >But when I use /etc/init.d/mysql start, the server can restart again. >So, what's wrong? >Maybe the path /var/run/mysqld is not right? > >Another quesion is when I use " SELECT Host, User FROM mysql.user;" >command in mysql, it >give me error: ERROR 1046 (3D000): No database selected. what is >"mysql.user" database? >Is it created automatically after start mysql first time? > >I just beginner of mysql. Please help! > Thanks a lot! ying "Ying Sun" <[EMAIL PROTECTED]> wrote: -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]