PHP MyAdmin: No Privelages

irish_stevo815

Hi guys, working on a small project for college and have run into some trouble when setting up a local host server (running Mac OS X 10.9.5). I have setup my MySQL and phpMyAdmin but i have "No Privileges" to create a database. I've also tried to create a database through terminal commands with mysql but get this error:

ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'testbase'

I have set up username as 'root' and password as 'password'. I'm at a complete loss here and tried everything i could find online. Any ideas??

I followed this tutorial to set it up

https://www.youtube.com/watch?v=3UOXIEWqPCw

Buford T Justice

How are you connecting via the command line? Looks like you've not specified a username. You should be connecting using

mysql -u root 'password'

in order to specify the username to have admin privileges.

irish_stevo815

Buford T Justice wrote: »

How are you connecting via the command line? Looks like you've not specified a username. You should be connecting using

mysql -u root 'password'

in order to specify the username to have admin privileges.

That just returns an error:

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

oscarBravo

Use

mysql -u root -p<password>

(without a space between -p and the password) or just

mysql -u root -p

to be prompted for a password.

irish_stevo815

Ok so i uninstalled MySQL and tried starting over. Using this tutorial http://www.maketecheasier.com/setup-web-server-in-mountain-lion/, it was all going ok until I got to setting up thre MySQL root password:

/usr/local/mysql/bin/mysqladmin -u root password 'password'

Returned the same errors:

connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'

oscarBravo

I'm not sure what's going on - have a look here and see if it helps.

moc moc a moc

irish_stevo815 wrote: »

/usr/local/mysql/bin/mysqladmin -u root password 'password'

This command will only work as-is if you don't already have a root password set up. Use the command oscarBravo gave you:

mysql -u root -p