This forum is no longer active. Please post your questions to our new community site

Forums LAMPStack

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

Subscribe to Default MySQL user has no privileges. At the end of my tether. 4 post(s), 2 voice(s)

Avatar chichilatte 2 post(s)

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 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 (… ). 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??

Avatar Beltrán Rueda Administrator 3,714 post(s)


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…

Avatar chichilatte 2 post(s)

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

Avatar Beltrán Rueda Administrator 3,714 post(s)

I’m glad to hear that.

Forums LAMPStack