[SOLVED] Permissions and privileges in phpMyAdmin issues

[ysg]

Hey all,

I tried setting a password for all of my XAMPP stuff. I made up a password with a '~' character in it and for some reason phpMyAdmin couldn't connect to the MySQL database. Very weird. When I set it to a password that didn't have the '~', it still couldn't connect. I proceeded to just leave the password field blank and clicked the button to login and... it logged in! That doesn't make any sense.

Another issue that I have is the fact that after I logged in... I couldn't create a table in phpMyAdmin in my database. That doesn't make any sense either. It said that I didn't have any privileges setup. My username is lampp, which is the default and _should_ have complete admin privileges, correct?

[JonB]

Linux usernames, XAMPP/LAMPP security, and MySQL have exactly ZERO to do with each other

Your Linux username is what you login with
Your XAMMP security stuff is permissions enabled by other applications and/or .htaccess/.htpswd prootcols
your MySQL username to 'do stuff' is 'root'

If you want passwords to work with more than one thing, stick to upper & lower case ASCII alphabetic characters and Arabic numerals (012345789). UNLESS you know the rules, skip periods, underscores, dashes and any other special characters.

OTAY???

[ysg]

Linux usernames, XAMPP/LAMPP security, and MySQL have exactly ZERO to do with each other

Your Linux username is what you login with
Your XAMMP security stuff is permissions enabled by other applications and/or .htaccess/.htpswd prootcols
your MySQL username to 'do stuff' is 'root'

If you want passwords to work with more than one thing, stick to upper & lower case ASCII alphabetic characters and Arabic numerals (012345789). UNLESS you know the rules, skip periods, underscores, dashes and any other special characters.

OTAY???

Right, I know that those are different passwords . I wasn't sure about how everything gets authenticated.

When I go to localhost, the username is lampp.
In phpMyAdmin, the username is also lampp. However, in here I can't create new databases... why? The root username for MySQL is root? How do I make phpMyAdmin aware of this so that it can access my database as root and so that I can do whatever?

[ysg]

I just unpackaged XAMPP from scratch and proceeded to have another go at it. I opened up phpMyAdmin and... I still can't by default create databases in MySQL, but I was able to do so before.

What is going on here? I don't get it.

[JonB]

How do I make phpMyAdmin aware of this so that it can access my database as root and so that I can do whatever?
ysg

Edit /opt/lampp/phpmyadmin/config.inc.php (as root)

Find the config.inc.php file and change the line:

Code: Select all

$cfg['Servers'][$i]['auth_type'] = 'cookie';

To
:

Code: Select all

$cfg['Servers'][$i]['auth_type'] = 'http';

This will require you to enter the database login details to use PMA. - then enter 'root' as the user name (provided a password has been set for 'root' in MySQL)
http://wiki.phpmyadmin.net/pma/Config

Good Luck

[ysg]

How do I make phpMyAdmin aware of this so that it can access my database as root and so that I can do whatever?
ysg

Edit /opt/lampp/phpmyadmin/config.inc.php (as root)

Find the config.inc.php file and change the line:

Code: Select all

$cfg['Servers'][$i]['auth_type'] = 'cookie';

To
:

Code: Select all

$cfg['Servers'][$i]['auth_type'] = 'http';

This will require you to enter the database login details to use PMA. - then enter 'root' as the user name (provided a password has been set for 'root' in MySQL)
http://wiki.phpmyadmin.net/pma/Config

Good Luck

Just tried that, it didn't work at all. Still can't create databases through phpMyAdmin.

And yes, after making that change, I did sudo ./lampp restart and still no change.

[JonB]

1. Are you getting a login prompt for phpMyAdmin? (right before you see the main screen)



2. What are you putting in at that login?

3. On the 'Home' phpMyAdmin page - what does it say in this area (over to the right).

[ysg]

Ok, now it seems to work... weird...

I removed /opt/lampp, then unpackaged 1.7.7 (which is what I had before), ran sudo ./lampp security and put in the same password everywhere (all lower-case letters with some numbers) and then went to the phpMyAdmin page, had the user as root and then typed in the password and all was good...

[ysg]

I think the issue was with how I was logging into phpMyAdmin. Initially I was using the user lampp, not root.