how to run mysqld

[leann]

i have installed this two rpm on redhat linux as 3
MySQL-client-4.0.18-0.i386.rpm
MySQL-server-4.0.18-0.i386.rpm

then ,i can see mysql in service , but when i :
[root@localhost root]# mysql
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

[root@localhost root]# mysql -h 127.0.0.1
ERROR 2003: Can't connect to MySQL server on '127.0.0.1' (111)

[root@localhost bin]# mysqld
Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!
051215 11:19:00 Aborting
051215 11:19:00 mysqld: Shutdown Complete


maybe i shouldnt start mysql as root , then i start mysql as user= mysql as follow:

chown mysql.mysql -R /var/lib/mysql
mysqld --user=mysql &

051220 11:09:16 InnoDB: Started
051220 11:09:16 Fatal error: Can't open privilege tables: File '/usr/share/mysql/charsets/?.conf' not found (Errcode: 2)
051220 11:09:16 Aborting

051220 11:09:16 InnoDB: Starting shutdown...
051220 11:09:18 InnoDB: Shutdown completed
051220 11:09:18 mysqld: Shutdown Complete

what is the problem, any help is appreciated, thank you!

[kkubasik]

servers like mysql and apache are generaly not started from the command line like that, instead they tend to reside in the startup scripts and as such are started with the system, to do it manualy, it should be something like.

/etc/init.d/mysqld start

but that will differ from system to system.

[leann]

thank you ! i follow your instruction,

[root@localhost root]# cd /etc/rc.d/init.d

[root@localhost init.d]# mysqld start
Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!
051221 9:37:11 Aborting
051221 9:37:11 mysqld: Shutdown Complete

[root@localhost init.d]# mysql start
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

[root@localhost init.d]# mysqld start --user=mysql &
[1] 2667
[root@localhost init.d]# 051221 9:43:36 InnoDB: Started
051221 9:43:36 Fatal error: Can't open privilege tables: File '/usr/share/mysql/charsets/?.conf' not found (Errcode: 2)
051221 9:43:36 Aborting
051221 9:43:36 InnoDB: Starting shutdown...
051221 9:43:38 InnoDB: Shutdown completed
051221 9:43:38 mysqld: Shutdown Complete


it is the same message, i dont know what to do.

[serz]

First do a "chown -R mysql.mysql /var/lib/mysql" and try to start mysql.

[devendra.meena]

# serviec mysqld start

[PorkFat]

# service mysqld start

Thank you so much for this info!

However, I set up mandriva to start mysql during boot-up but it still will not. How do I set it to start manually during boot time?

Thanks

[PorkFat]

Thank you so much for this info!

However, I set up mandriva to start mysql during boot-up but it still will not. How do I set it to start manually during boot time?

Thanks

According to these directions:

http://www.howtoforge.com/perfect_se...ndriva_2006_p5

I'm supposed to be able to run mysqld without having to type "service" first. Why would his work, do I have a newer version? I'd really like to have mine work the way it's supposed to and load up when I boot my system.

*edit* Well, it booted and started mysql but I don't know how it changed. I guess starting it with the "service" line enabled it to come up during boot?

[ramrumram]

/usr/local/mysql$ sudo ./bin/mysqld --user=root &
This Works for me!