標(biāo)題: 解決mysql安裝mysqld doesn\'t exist or is not [打印本頁] 作者: 鳥哥のlinux 時(shí)間: 2011-12-23 01:23 標(biāo)題: 解決mysql安裝mysqld doesn\'t exist or is not 最近phpwind升級8.7后，經(jīng)常出現(xiàn)宕機(jī)的現(xiàn)象，不是Apache卡死，吃光內(nèi)存機(jī)器重啟，就是mysql數(shù)據(jù)庫被鎖，無奈！ 多個(gè)原因，apache的版本過低，導(dǎo)致執(zhí)行效率慢；另外數(shù)據(jù)庫版本過低，查詢語句多時(shí)，自動鎖！網(wǎng)站幾乎不能訪問！另外就是程序可能也有點(diǎn)問題，測試頁面可以正常訪問！主頁卻不能打開！
[root@localhost scripts]# /usr/local/mysql5.0.45/bin/mysqld_safe --defaults-file=/etc/my.cnf --user=mysql & [1] 31358 [root@localhost scripts]# The file /usr/local/mysql/bin/mysqld doesn't exist or is not executable Please do a cd to the mysql installation directory and restart this script from there as follows: ./bin/mysqld_safe. See http://dev.mysql.com/doc/mysql/en/mysqld_safe.html for more information \ [1]+ Exit 1 /usr/local/mysql5.0.45/bin/mysqld_safe --defaults-file=/etc/my.cnf --user=mysql
查看了很多資料，最終還是官方的文檔給力：
5. Change location into the installation directory:
shell> cd mysql
You will find several files and subdirectories in the `mysql' directory. The most important for installation purposes are the `bin' and `scripts' subdirectories:
* The `bin' directory contains client programs and the server. You should add the full pathname of this directory to your `PATH' environment variable so that your shell finds the MySQL programs properly. See *Note environment-variables::.
* The `scripts' directory contains the `mysql_install_db' script used to initialize the `mysql' database containing the grant tables that store the server access permissions.
6. Ensure that the distribution contents are accessible to `mysql'. If you unpacked the distribution as `mysql', no further action is required. If you unpacked the distribution as `root', its contents will be owned by `root'. Change its ownership to `mysql' by executing the following commands as `root' in the installation directory:
shell> chown -R mysql . shell> chgrp -R mysql .
The first command changes the owner attribute of the files to the `mysql' user. The second changes the group attribute to the `mysql' group.
7. If you have not installed MySQL before, you must create the MySQL data directory and initialize the grant tables:
shell> scripts/mysql_install_db --user=mysql
If you run the command as `root', include the `--user' option as shown. If you run the command while logged in as that user, you can omit the `--user' option.
The command should create the data directory and its contents with `mysql' as the owner.
After creating or updating the grant tables, you need to restart the server manually.
8. Most of the MySQL installation can be owned by `root' if you like. The exception is that the data directory must be owned by `mysql'. To accomplish this, run the following commands as `root' in the installation directory:
shell> chown -R root . shell> chown -R mysql data
9. If you want MySQL to start automatically when you boot your machine, you can copy `support-files/mysql.server' to the location where your system has its startup files. More information can be found in the `support-files/mysql.server' script itself and in *Note automatic-start::.
我之前執(zhí)行的是 chown -R mysql：mysql .
官方： shell> chown -R root .
shell> chown -R mysql data
最后修正重啟： [root@localhost mysql5.0.45]# chown -R root . [root@localhost mysql5.0.45]# chown -R mysql data [root@localhost mysql5.0.45]# ./bin/mysqld_safe --user=mysql & [1] 31480 [root@localhost mysql5.0.45]# Starting mysqld daemon with databases from /mysqldata
關(guān)閉重啟： [root@localhost mysql5.0.45]# /usr/local/mysql5.0.45/bin/mysqladmin -u root shutdown STOPPING server from pid file /mysqldata/localhost.localdomain.pid 110928 10:49:34 mysqld ended
[1]+ Done ./bin/mysqld_safe --user=mysql [root@localhost mysql5.0.45]# ./bin/mysqld_safe --user=mysql & [1] 31654 [root@localhost mysql5.0.45]# Starting mysqld daemon with databases from /mysqldata