求助:mysql

ctgboy

各位大侠,我的mysql出现如下问题:在启动时出现
Usage: /etc/init.d/mysql start|stop|restart
我在命令下输入mysql时出现
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/m ysql.sock' (2),可是在此目录下没有此文件,重新安装mysql时出现
[root@proxy mysql-4.0.20]# ./configure
NOTE: This is a MySQL binary distribution. It's ready to run, you don't
need to configure it!

To help you a bit, I am now going to create the needed MySQL databases
and start the MySQL server for you.  If you run into any trouble, please
consult the MySQL manual, that you can find in the Docs directory.

Installing all prepared tables
040708 12:41:14  Warning: Asked for 196608 thread stack, but got 126976
040708 12:41:14  ./bin/mysqld: Shutdown Complete


To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
./bin/mysqladmin -u root password 'new-password'
./bin/mysqladmin -u root -h proxy.ctgf.com.cn password 'new-password'
See the manual for more instructions.

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

You can start the MySQL daemon with:
cd . ; ./bin/mysqld_safe &

You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory:
cd sql-bench ; perl run-all-tests

Please report any problems with the ./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 the mysqld server.  You can test that it is up and running
with the command:
./bin/mysqladmin version
[root@proxy mysql-4.0.20]# Starting mysqld daemon with databases from /var/lib/mysql
请各位高高手帮助解决,谢谢

smile787

NOTE: This is a MySQL binary distribution. It's ready to run
程序告诉你了不用去configure，直接运行！！！

复制mysql.server到你的系统/etc/init.d/或者你想要的地方！！这个是主程序，你运行的mysql是clint端

设置你的密码这样来做
mysqladmin -u root password '你的密码'


启动你的mysql.server，就可以运行命令mysqladmin version
看版本号。


再有错误贴一下！！多看精华贴

ctgboy

还是不行啊,我使用的是linux as 3,mysql是3.23.58-1,mysql.server到我的系统/etc/init.d,运行,出现Can't execute ./bin/mysqld_safe from dir /var/lib
root@localhost#mysqladmin -u root password
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!

smile787

运行过mysql_install_db的什么没有？里面有readme文档。都有说名！