LinuxQuestions.org - MySQL not starting Up?

- Linux - Newbie (https://www.linuxquestions.org/questions/linux-newbie-8/)

- - MySQL not starting Up? (https://www.linuxquestions.org/questions/linux-newbie-8/mysql-not-starting-up-663574/)

MySQL not starting Up?

I have been facing the problem during the mysql starting up.Anyone who can help me get rid of that:

Code:

root@tuxbuddy tmp]# mysql -u root -p



Enter password:



ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)



[root@tuxbuddy  tmp]# cd



[root@tuxbuddy  ~]# mysqladmin -u root password 'mysql123'



mysqladmin: connect to server at 'localhost' failed



error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'



Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!



[root@tuxbuddy  ~]# service mysql stop



MySQL manager or server PID file could not be found!      [FAILED]



[root@tuxbuddy  ~]# rpm -qa | grep mysql

Did you try

service mysql start

?

edit - what distro are you running - it may be mysqld

Note there is a server and a client

So did this command produce no output ?

Code:

[root@tuxbuddy ~]# rpm -qa | grep mysql

Ya the Server and Clients are there.
All It has mysql but not mysqld as daemon?

Am I missing any package?

Do a ps and grep mysqld?

ps fax | grep mysqld

And see if any process is running. If not, try to start it up and give us exact error from the logs, not what's outputted on the console or terminal.

[root@tuxbuddy~]# rpm -e --nodeps MySQL-client-standard-5.0.18-0.rhel4
[root@ ~]# rpm -e --nodeps MySQL-python-1.2.1_p2-1.el4.1
[root@ ~]# rpm -e --nodeps MySQL-server-standard-5.0.18-0.rhel4
[[root@ ~]# service mysql restart
mysql: unrecognized service
[root@ ~]# rpm -e --nodeps mysql-8
error: package mysql-8 is not installed
[root@ ~]# rpm -e --nodeps mysql-*
error: package mysql-* is not installed
[root@ ~]# ls
[root@ ~]# cd /tmp
[root@ tmp]# rpm -ivh MySQL-server-standard-5.0.18-0.rhel4.x86_64.rpm
warning: MySQL-server-standard-5.0.18-0.rhel4.x86_64.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
Preparing... ########################################### [100%]
1:MySQL-server-standard ########################################### [100%]
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h BL08DL385.mailserver.com password 'new-password'
See the manual for more instructions.

NOTE: If you are upgrading from a MySQL <= 3.22.10 you should run
the /usr/bin/mysql_fix_privilege_tables. Otherwise you will not be
able to use the new GRANT command!

Please report any problems with the /usr/bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at https://order.mysql.com
Starting MySQL...................................[FAILED]
[root@ tmp]#

It Says:

MySQL manager or server PID file could not be found!

Now you've installed the server, you need to start it. Try service mysqld start (note that mysql is the client, mysqld is the server)

[root@tmp]# service mysqld restart
mysqld: unrecognized service
[root@tmp]#

FYI

Ok...I donno whats going on..
I want to install a new SQL Package ...How to go for that?

Pls Help

Looks to me like the Mysql Deamon failed to install properly. The file for mysqld was not added to /etc/init.d/ what makes me think it failed somewhere but what you got is not saying where that is. you could check /etc/init.d/ for a mysqld related file but my guess is it isn't their.

What does

find / -type f -name *mysqld*

show?

Are you running RHEL4? Where did you get the rpm you are installing?

Quote:

Originally Posted by billymayday (Post 3252278)

What does

find / -type f -name *mysqld*

I prefer updating the db with updatedb and then using locate, much faster. You can also use the which command when looking for a specific command.

Quote:

Originally Posted by trickykid (Post 3252658)

I prefer updating the db with updatedb and then using locate, much faster. You can also use the which command when looking for a specific command.

So do I for my use, but I prefer to give a cut and paste soln where possible.

Cheers

BM