若您是用Access，這篇您就不用看了。
這是介紹如何登入管理員用的Mysql，預設的port 8306，不是一般的3306
參考網址:
1. Open Command Prompt. Go to MySQL Service directory which should be under your Plesk directory. E.g: "D:\Parallels\Plesk\MySQL\bin"
Type: mysql -uadmin -p"your_plesk_password" -P8306 (就是你登入Plesk後台管理的密碼)
或是: mysql -uadmin -p -P8306 (之後會提示輸入密碼)
This will take you to mysql prompt "mysql>"
2. You can list the databases by command "SHOW Databases;"
3. Select the Database "psa" by command "USE psa;"
This will take you inside the psa DB.
4. You need to open a Table named "databaseservers" where all the database Server information is saved.
To do so,type "select * from databaseservers" //這裡可以看到你用戶專用的db含mysql, mssql設定的資料庫管理帳密，沒有加密
This should open up the Databaseserver table where the password for MySQL Server is mentioned.
留言列表
