Welcome Guest. Please Login or Register  


You are here: Index > Webuzo > General Support > Topic : Cant Access MySQL via Panel and Console



Threaded Mode | Print  

 Cant Access MySQL via Panel and Console, Cant Access MySQL via Panel and Console (5 Replies, Read 25149 times)
andiklive
Group: Member
Post Group: Working Newbie
Posts: 50
Status:
Hello Webuzo Team,
i cant access mysql and create via Panel (Manage Database and Add Database) also i cant login via console too.
even using root via console, i got root password at /var/webuzo/my.cnf
i think it about privilliage database.

but i check my website is running using the database.
any solutions to fix this.
thanks

-----------------------
Get Free $50 VULTR Cloud Servers Credit

IP: --   

Cant Access MySQL via Panel and Console
valley
Group: Webuzo Team
Post Group: Super Member
Posts: 1644
Status:
You should be able to login to phpmyadmin with the username "root" and the password located in the file /var/webuzo/my.cnf

-----------------------
Webuzo : Single User Control Panel
Join Webuzo :
Facebook
Twitter

IP: --   

Cant Access MySQL via Panel and Console
andiklive
Group: Member
Post Group: Working Newbie
Posts: 50
Status:
still cant login via phpmyadmin too.

oh i forgot mention that database name and database username is not listed too on "Manage Database" in Webuzo Panel.
but database data is exist on /var/lib/mysql/

-----------------------
Get Free $50 VULTR Cloud Servers Credit

IP: --   

Cant Access MySQL via Panel and Console
valley
Group: Webuzo Team
Post Group: Super Member
Posts: 1644
Status:
Quote From : andiklive October 30, 2014, 9:40 am
still cant login via phpmyadmin too.

oh i forgot mention that database name and database username is not listed too on "Manage Database" in Webuzo Panel.
but database data is exist on /var/lib/mysql/


If you are able to view other databases in the Webuzo Enduser Panel >> Manage Databases, you should be able to login with the details.

Further, if you have created databases and users manually, then make sure the database user has privileges to access the database.
http://www.webuzo.com/wiki/How_to_Create_and_Manage_MySQL_Databases#Set_Privileges_for_the_Database_and_Host

Hope this helps


-----------------------
Webuzo : Single User Control Panel
Join Webuzo :
Facebook
Twitter

IP: --   

Cant Access MySQL via Panel and Console
andiklive
Group: Member
Post Group: Working Newbie
Posts: 50
Status:
Quote From : valley October 31, 2014, 6:11 am
Quote From : andiklive October 30, 2014, 9:40 am
still cant login via phpmyadmin too.

oh i forgot mention that database name and database username is not listed too on "Manage Database" in Webuzo Panel.
but database data is exist on /var/lib/mysql/


If you are able to view other databases in the Webuzo Enduser Panel >> Manage Databases, you should be able to login with the details.

Further, if you have created databases and users manually, then make sure the database user has privileges to access the database.
http://www.webuzo.com/wiki/How_to_Create_and_Manage_MySQL_Databases#Set_Privileges_for_the_Database_and_Host

Hope this helps


i think its bacause root privileges, beacuse  istill access another user via console.
also, i cant reset password using mysql_safe

PHP Code

 [root@server ~]# service mariadb stop
Shutting down MySQLSUCCESS
[
root@server ~]# mysqld_safe --skip-grant-tables --skip-networking
141108 00:29:27 mysqld_safe Logging to '/var/log/mysqld.log'.
141108 00:29:28 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
141108 00
:29:29 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
[root@server ~]



-----------------------
Get Free $50 VULTR Cloud Servers Credit

IP: --   

Cant Access MySQL via Panel and Console
valley
Group: Webuzo Team
Post Group: Super Member
Posts: 1644
Status:
You can check the logs to learn more

/var/log/mysqld.log

-----------------------
Webuzo : Single User Control Panel
Join Webuzo :
Facebook
Twitter

IP: --   

« Previous    Next »

Threaded Mode | Print  



Jump To :


Users viewing this topic
1 guests, 0 users.


All times are GMT. The time now is March 28, 2024, 1:12 pm.

  Powered By AEF 1.0.8 © 2007-2008 Electron Inc.Queries: 11  |  Page Created In:0.028