<ruby id="5hvrh"><ins id="5hvrh"></ins></ruby><ruby id="5hvrh"></ruby>
<strike id="5hvrh"></strike>
<th id="5hvrh"></th>
<span id="5hvrh"><noframes id="5hvrh">
<th id="5hvrh"></th><strike id="5hvrh"><video id="5hvrh"></video></strike><span id="5hvrh"></span>
<strike id="5hvrh"><noframes id="5hvrh"> <strike id="5hvrh"><noframes id="5hvrh"><span id="5hvrh"></span><th id="5hvrh"></th>
<strike id="5hvrh"><noframes id="5hvrh"><th id="5hvrh"></th><span id="5hvrh"><video id="5hvrh"></video></span><strike id="5hvrh"><noframes id="5hvrh">

企業網站托管

企業門戶的基礎配置,多端適配,完美展示企業信息

lnmp1.7安裝環境后mysql無法啟動的解決

文章出處:本站原創 | 發表時間:2021-01-31 23:51:02

使用lnmp1.7快速搭建的集成環境,在訪問自帶的phpmyadmin時提示:

mysqli_real_connect(): (HY000/2002): No such file or directory

在/etc/my.conf中修改host為127.0.0.1,無效

重新啟動mysql,報錯:

Starting MySQL... ERROR! The server quit without updating PID file (/usr/local/mysql/var/host1.pid).

查看host1.err文件,發現有類似如下錯誤:

Table 'mysql.plugin' doesn't exist
...
Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
...
Table 'mysql.servers' doesn't exist.

提示執行mysql_upgrade命令創建,但如果你執行mysql_upgrade時報錯,會提示如下錯誤:

Error: Failed while fetching Server version! Could be due to unauthorized access.

這其實在mysql安裝時一些關鍵信息沒有創建成功,需要使用mysql_install_db命令重建,使用如下命令:

/usr/local/mysql/scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var &

以上注意datadir目錄要是my.conf中配置的目錄!網上有些教程中這里寫的是/usr/local/mysql/data/ 。

執行成功后,重新啟動mysql(lnmp start mysql)成功。

啟動后可能需要重置mysql root密碼,使用:

/usr/local/mysql/bin/mysqladmin -u root password '你的新密碼'

(注意mysqladmin路徑,你的或許不在這個目錄,可以看看/usr/bin/)

鲁丝片一区鲁丝片二区鲁丝片三区
<ruby id="5hvrh"><ins id="5hvrh"></ins></ruby><ruby id="5hvrh"></ruby>
<strike id="5hvrh"></strike>
<th id="5hvrh"></th>
<span id="5hvrh"><noframes id="5hvrh">
<th id="5hvrh"></th><strike id="5hvrh"><video id="5hvrh"></video></strike><span id="5hvrh"></span>
<strike id="5hvrh"><noframes id="5hvrh"> <strike id="5hvrh"><noframes id="5hvrh"><span id="5hvrh"></span><th id="5hvrh"></th>
<strike id="5hvrh"><noframes id="5hvrh"><th id="5hvrh"></th><span id="5hvrh"><video id="5hvrh"></video></span><strike id="5hvrh"><noframes id="5hvrh">