剛剛裝好linux as 4.
現(xiàn)在面臨的第一個問題就是怎么用上自帶mysql>[root@server tmp] rmp -qa|grep mysql 察看當前mysql版本.
一:
當我在命令行輸入mysql時出現(xiàn)了:Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.soc的錯誤的話.-
解決的辦法是:由于mysql 服務(wù)還沒有啟動。試試看:>>>service mysqld starty
二:
root@localhost www]# service mysqld start
Initializing MySQL database: Neither host 'localhost' nor 'localhost' could be looked up with
/usr/bin/resolveip
Please configure the 'hostname' command to return a correct hostname.
If you want to solve this at a later stage, restart this script with
the --force option
[FAILED]
[root@localhost www]#
處 理:
1、$ ping localhost
ping: unknown host localhost
ping也不成功,確定可能為localhost解析原因。
2、查看/etc/hosts,內(nèi)容如下:
# Do not remove the following line, or various programs
# that require network functionality will fail.
::1 localhost.localdomain localhost
3、將::1修改為127.0.0.1后,啟動成功。
三:mysqladmin -u root -p password
想輸入空密碼,但居然說
mysqladmin:connect to server at'localhost' failed
erroe:'acces denied for user 'root@127.0.0.1'
試試這個:>mysql -u root -p 123456
Enter password:123456
或者參考:
使用網(wǎng)上介紹的方法修改root用戶的密碼:
# mysqladmin -uroot -p password 'newpassword'
Enter password:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'
現(xiàn)在終于被我找到了解決方法,如下(請先測試方法三,謝謝。
方法一:
# /etc/init.d/mysql stop
# mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
# mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD('newpassword') where USER='root';
mysql> FLUSH PRIVILEGES;
mysql> quit
# /etc/init.d/mysql restart
# mysql -uroot -p
Enter password: <輸入新設(shè)的密碼newpassword>
本文出自:億恩科技【mszdt.com】
服務(wù)器租用/服務(wù)器托管中國五強!虛擬主機域名注冊頂級提供商!15年品質(zhì)保障!--億恩科技[ENKJ.COM]
|