Mysql and superuser

kuplo · 12-06-2005, 08:50 AM

I've added my username 3 times, once by itself, once with local host and once with my host domain, I've given myself permission databaes but when I connect I get an permission error, I dont rememember how I did it before in mysql-Administrator but I made myself a superuser and had no problems after that. HOw do I go about doing that again?

Thanks,

trickykid · 12-06-2005, 09:00 AM

mysql> GRANT ALL PRIVILEGES ON *.* TO username@hostname IDENTIFIED BY 'password' WITH GRANT OPTIONS;

mysql> flush privileges;

mysql> quit

$ mysql -uUserName -pPassword

mysql>