Page 1 of 1

phpMyAdmin not showing my databases

PostPosted: 24. September 2013 05:03
by originalhandy
I have been using XAMPP for about a year and upgraded to 1.8.2 about 2 months ago.
When I logged onto localhost/phpmyadmin and got the XAMPP message about new changes in the http-conf file I think it was. (New XAMPP security concept)
I did /opt/lampp/lampp security

Now I can access localhost/phpmyadmin but it dos not show any of my databases from my website. I see information schema, mysql, phpmyadmin and test. None of these are my websites.
When I go to /var/mysql my databse for my website is in there. Any ideas ?

Re: phpMyAdmin not showing my databases

PostPosted: 24. September 2013 05:29
by Altrea
you are logged in with an anonymous user who don't has any permissions.

change your phpMyAdmin setting auth_type from "config" to "cookie" and log in manually with your new credentials.
http://docs.phpmyadmin.net/en/latest/co ... _auth_type

Re: phpMyAdmin not showing my databases

PostPosted: 24. September 2013 18:07
by originalhandy
Thanks you were spot on!

Cant create database #1044 access denied

PostPosted: 27. September 2013 19:35
by originalhandy
I did a reinstall to the latest XAMPP and when I am on loclahost/phpmyadmin and try to create a database I get
Code: Select all
#1044 Access denied for user "@'localhost' to database 'website'


SQL is started, fresh install. I have done /opt/lampp/lampp security also.

LAMPP is running fine it says
Code: Select all
Version: XAMPP for Linux 1.8.3-1
Apache is running.
MySQL is running.
ProFTPD is running.
ws-19476:/opt/lampp/phpmyadmin #



Any ideas ?

I have auth set to cookie, do I need to edit anythng else there
Code: Select all
 * First server
 */
$i++;
/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
/* Server parameters */
//$cfg['Servers'][$i]['host'] = 'localhost';
//$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
/* Select mysql if your server does not have mysqli */
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['AllowNoPassword'] = true;



[Moderated by Altrea: Merged Threads]

Re: Cant create database #1044 access denied

PostPosted: 27. September 2013 21:16
by Altrea
login with root@localhost not with anonymous@localhost.
I have already told you that so please stop creating new threads for the same issue