Control Web Panel

WebPanel => MySQL => Topic started by: stefy97100 on June 20, 2014, 01:51:51 PM

Title: SQL Problem
Post by: stefy97100 on June 20, 2014, 01:51:51 PM

I have some problem with MySQL.
1) How I can login to phpMyAdmin?? On /etc I haven't any "webpanel" folder.
2) If I try to create the database on "MySQL Manager" I get this error "Something is missing!" (http://dumpshare.net/images/6650654Cattura.JPG (http://dumpshare.net/images/6650654Cattura.JPG))

Title: Re: SQL Problem
Post by: Administrator on June 20, 2014, 02:02:32 PM

you need to check that you have correct root password for mysql

you can check if you have mysql root password set with this command

Code: [Select]

mysql -uroot
mysql root password locations:

for shell

Code: [Select]

cat /root/.my.cnf
or for CWP

Code: [Select]

cat /usr/local/cwpsrv/htdocs/admin/include/db_conn.php

Title: Re: SQL Problem
Post by: stefy97100 on June 20, 2014, 02:07:10 PM

Ok, I found the password for phpMyAdmin but I still have this error "Something is missing!"

Problem 3: what is the user and password for ftp?

Title: Re: SQL Problem
Post by: Administrator on June 20, 2014, 06:06:12 PM

you need to check db connection file

/usr/local/cwpsrv/htdocs/admin/include/db_conn.php

FTP user and password is what you create via New account.
if you need root user than you need to use SFTP