US: 1-941-4621-069
  
Cyprus: 3-572-2052-781

Go Back   ISPsystem.com Forums > ISPmanager > Troubleshooting


Reply
 
Thread Tools
Old 06-16-2015, 08:29 AM   #1
Junior Member
 
Join Date: Sep 2014
Posts: 1
ispccare is on a distinguished road
Default Mysql 'access denied, root using password: Yes'

Hello all,

I am working with my own ISP Manager 5 Pro environment. However yesterday we found out that we cannot access anything for mysql.

We are getting the following error:

Untitled.png

Anybody know where I can find this?
ispccare is offline   Reply With Quote
Old 06-18-2015, 05:02 PM   #2
ISPsystem team
 
Join Date: Jun 2013
Posts: 233
fly is on a distinguished road
Default

Hello,

Please check if mysql server is running. Also check if the password ISPmanager used is correct. To check the password connect to the database (on a server with mysql role)
/usr/local/mgr5/sbin/sqlite3 /usr/local/mgr5/etc/ispmgrnode.db
and do a select:
sqlite> select * from db_server;
id|name|type|host|username|password|savedver
1|MySQL|mysql|localhost|root|2wvALvEfha|5.1.73-cll-lve

You will see a password that ISPmanager uses.
fly is offline   Reply With Quote
Reply

Tags
access, denied, mysql, password, root

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +2. The time now is 10:04 PM.