请帮我看看,我的mysql是什么问题?

mazx1969

# ./mysql_install_db
Installing all prepared tables
040102 11:15:42  /usr/local/mysql/libexec/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 !
This is done with:
/usr/local/mysql/bin/mysqladmin -u root  password 'new-password'
/usr/local/mysql/bin/mysqladmin -u root -h dgytgs-solaris  password 'new-passwor
d'
See the manual for more instructions.

NOTE:  If you are upgrading from a MySQL <= 3.22.10 you should run
the /usr/local/mysql/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 /usr/local/mysql ; /usr/local/mysql/bin/safe_mysqld &

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

Please report any problems with the /usr/local/mysql/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

# ./mysqladmin -u root password '970501'
./mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (14
6)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!
#

南非蜘蛛

这个问题，我想回答，我去找找资料

南非蜘蛛

mysql不能通过'/tmp/mysql.sock'的解决办法
经常有人抱怨配好的php不能连到mysql，但mysql确实又启动了，而且可以正常连接。

这个问题主要提示是，不能通过'/tmp/mysql.sock'连到服务器，而php标准配置正是用过'/tmp/mysql.sock'，但是一些mysql安装方法将mysql.sock放在/var/lib/mysql.sock或者其他的什么地方，你可以通过修改/etc/my.conf文件来修正它，打开文件，可以看到如下的东东：

[mysqld]
socket=/var/lib/mysql.sock

改一下就好了，但也会引起其他的问题，如mysql程序连不上了，再加一点：

[mysql]
socket=/tmp/mysql.sock

或者还可以通过修改php.ini中的配置来使php用其他的mysql.sock来连，这个大家自己去找找

还有一个办法：
ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock

mazx1969

还是不行呀,

文件都存有呀!

一个在:/tmp/mysql.sock
另一个在:/var/tmp/mysql.sock

不过2个文件内容均为空!

还有,我还没装好php呢!

南非蜘蛛

原帖由 "mazx1969" 发表：
还是不行呀,

文件都存有呀!

一个在:/tmp/mysql.sock
另一个在:/var/tmp/mysql.sock

不过2个文件内容均为空!

还有,我还没装好php呢!

从起机器吧

mazx1969

我试试

mazx1969

重起服务器还是不行,蜘蛛姐姐

# ./safe_mysqld &
325
# Starting mysqld daemon with databases from /usr/local/mysql/var
040102 11:51:18  mysqld ended


# ./mysql_install_db
Installing all prepared tables
040102 11:51:39  /usr/local/mysql/libexec/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 !
This is done with:
/usr/local/mysql/bin/mysqladmin -u root  password 'new-password'
/usr/local/mysql/bin/mysqladmin -u root -h dgytgs-solaris  password 'new-passwor
d'
See the manual for more instructions.

NOTE:  If you are upgrading from a MySQL <= 3.22.10 you should run
the /usr/local/mysql/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 /usr/local/mysql ; /usr/local/mysql/bin/safe_mysqld &

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

Please report any problems with the /usr/local/mysql/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

# ./mysqlshow
./mysqlshow: Can't connect to local MySQL server through socket '/tmp/mysql.sock
' (146)
#

南非蜘蛛

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

mazx1969

拷到哪儿呢?