[已解決] Wdcp 數(shù)據(jù)庫連接服務(wù)，求助

lixi.china

求助朋友。

網(wǎng)站數(shù)據(jù)庫連接不上了，wdcp也啟動不了，請看截圖。我該怎么做？找了一天了都沒找到解決的方案。

在網(wǎng)上找到了這樣的方法，但是還是沒有解決問題；

ERROR 1045 (28000): Access denied for user root@localhost (using password: NO)

# sudo /etc/init.d/mysql stop
# sudo 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

但是網(wǎng)站還是顯示這樣。不知道怎么解決。謝謝。

使用的版本是ＷＤＣＰ�。�.３

lixi.china

請老大給個指點，謝謝了

liangwei

很明顯的錯誤啊  你修改端口了

admin

端口已被使用

提問三步曲:
1 對應(yīng)版塊,提供系統(tǒng)版本位數(shù),wdcp版本,lamp,lnmp,lnamp是哪個環(huán)境
2 有哪些錯誤信息或提示,貼上論壇或截圖發(fā)論壇
3 做過哪些操作或更改或設(shè)置等詳細(xì)說明
信息不詳者,一律不解答,謝謝

lixi.china

回復(fù)老大，我應(yīng)該沒有更改端口，是不是誤操作導(dǎo)致的��？
我使用的是lnamp，wdcp 2.3 版本。
有沒有這個問題的解決辦法？

在線等，謝謝了。

admin

這種問題,沒有應(yīng)該,有就有,沒有就沒有

誤操作,那你都做過哪些操作?看不到發(fā)貼三步曲嗎

3 做過哪些操作或更改或設(shè)置等詳細(xì)說明

從你上面的截圖看,8080端口是給nginx用了,如果你沒改過,是不可能的,除非是1.x

lixi.china

謝謝老大回復(fù)，給您發(fā)郵件了

lixi.china

我剛才問了，應(yīng)該是有人改了我的php.ini,以下是配置文件，數(shù)據(jù)庫還是顯示：
Access denied for user 'root'@'localhost' (using password: NO)
網(wǎng)站還是連不上。

另外，nginx占用8080端口已經(jīng)解決了，wdcp后臺可以訪問。現(xiàn)在版本是wdcp 2.4，lnamp環(huán)境。

看看php.ini 關(guān)于mysql的設(shè)置，是不是配置問題導(dǎo)致的？
mysql.max_links = -1

; Default port number for mysql_connect().  If unset, mysql_connect() will use
; the $MYSQL_TCP_PORT or the mysql-tcp entry in /etc/services or the
; compile-time value defined MYSQL_PORT (in that order).  Win32 will only look
; at MYSQL_PORT.
mysql.default_port =

; Default socket name for local MySQL connects.  If empty, uses the built-in
; MySQL defaults.
mysql.default_socket =

; Default host for mysql_connect() (doesn't apply in safe mode).
mysql.default_host =

; Default user for mysql_connect() (doesn't apply in safe mode).
mysql.default_user =

; Default password for mysql_connect() (doesn't apply in safe mode).
; Note that this is generally a *bad* idea to store passwords in this file.
; *Any* user with PHP access can run 'echo get_cfg_var("mysql.default_password")
; and reveal this password!  And of course, any users with read access to this
; file will be able to reveal the password as well.
mysql.default_password =

; Maximum time (in seconds) for connect timeout. -1 means no limit
mysql.connect_timeout = 60

; Trace mode. When trace_mode is active (=On), warnings for table/index scans and
; SQL-Errors will be displayed.
mysql.trace_mode = Off

[MySQLi]

; Maximum number of links.  -1 means no limit.
mysqli.max_links = -1

; Default port number for mysqli_connect().  If unset, mysqli_connect() will use
; the $MYSQL_TCP_PORT or the mysql-tcp entry in /etc/services or the
; compile-time value defined MYSQL_PORT (in that order).  Win32 will only look
; at MYSQL_PORT.
mysqli.default_port = 3306

; Default socket name for local MySQL connects.  If empty, uses the built-in
; MySQL defaults.
mysqli.default_socket =

; Default host for mysql_connect() (doesn't apply in safe mode).
mysqli.default_host =

; Default user for mysql_connect() (doesn't apply in safe mode).
mysqli.default_user =

; Default password for mysqli_connect() (doesn't apply in safe mode).
; Note that this is generally a *bad* idea to store passwords in this file.
; *Any* user with PHP access can run 'echo get_cfg_var("mysqli.default_pw")
; and reveal this password!  And of course, any users with read access to this
; file will be able to reveal the password as well.
mysqli.default_pw =

; Allow or prevent reconnect
mysqli.reconnect = Off

admin

跟php.ini沒有關(guān)系的
你們仔細(xì)檢查,及回想看下做過哪些更改和設(shè)置操作吧

lixi.china

回復(fù)，問題已經(jīng)得到解決。
采用了比較原始的方法。

重裝了系統(tǒng)！

問題得到解決