unable to access database from admin panel.
Me and my buddy are running a site and using mysql to store user info and other relevant data. Thing is we can't see any users when we log into the site's admin panel, but the users and everything else is being saved properly into mysql db and shows up fine in phpmyadmin.
Now I am pretty new to SQL in general. If assuming the code for the admin panel is correct (its a custom written admin panel) and it is making valid queries to sql. What sort of user privileges should be set to show those tables/columns in the admin panel.
Does it need the same name as the login id,
Any help appreciated.
5 Replies
I'd take a look through the code for a config file – it'll give you the MySQL username (and usually) the password as well. This set of credentials is completely separate from other things. You can use SHOW GRANTS FOR once you're in.
Take a look at the MySQL tunneling guide so you can edit your stuff locally:
Good luck
I have checked the conifg.inc.php file and the database details are fine in there and the connection to the database is working also.
If my question isn't clear or vague please ask me for clarification. I tried to explain clearly about what I am trying to accomplish.
netstat -lvpnut | grep 3306
If there is no output, then any application trying to connect to MySQL over the network interface will fail. Your choices are to point the application to the appropriate UNIX socket file (probably something like /var/lib/mysql/mysql.sock) or enable networking in MySQL.
Edit: missed you saying that the client was connecting OK. In that case, try logging