Default MySQL user has no privileges. At the end of my tether.

I’ve got the Lampstack running perfectly on EC2 (with webmin too, alright!). Well, near perfect. I’m having problems doing anything useful with MySQL.

I can login to phpMyAdmin with the username “Administrator” or “bitnami” without a password (i tweaked the config.inc.php file to allow this), but under “Create new database” it says “No Privileges”.

Or, on the command line, running MySQL with “mysql -u bitnami” and trying…

UPDATE user SET password = PASSWORD WHERE user = ‘bitnami’

…gives the answer…
Access denied for user ’’@’localhost’ to database ‘mysql’

Or using mysqladmin…
sudo mysqladmin -u bitnami password farts
give me…
Access denied; you need the SUPER privilege for this operation’

I even tried the “mysqld_safe —skip-grant-tables” route ( http://www.ubuntugeek.com/reset-the-root-passwo… ). No go.

MySQL doesn’t seem to have a “root” user, so i always used either bitnami or Administrator.

How the blazing hellcats do i get the MySQL privileges to do anything useful??

Hi,

You should use the “root” user to login in the database, not sure why you said that you can not log in. Check that you can login using the command “mysql -u root -p” from the same machine. The password is bitnami. You can also login in the phpMyAdmin application but it is not public for security reasons. Check the following link and post if you continue having problems http://wiki.bitnami.com/Components/phpMyAdmin_a…

Hooray! Thanks Beltrán! I was obviously wrong about root. Still learning :)

I’m glad to hear that.