Portal Home > Knowledgebase > Articles Database > enable root for mysql
enable root for mysql
| Posted by subnoizerat420, 11-09-2007, 03:16 PM |
| I was wondering how to re-enable the root user for mysql?
My webhost "disabled it by default"
I am not very pleased with this, and if you are an owner of a webhost company reading this, please note that.
Thank you!
And sorry if this is the wrong forum to post this in
|
| Posted by david510, 11-09-2007, 05:54 PM |
| You need login to the mysql prompt as user root from the root SSH prompt?
|
| Posted by subnoizerat420, 11-09-2007, 10:25 PM |
| Yes, thanks
|
| Posted by david510, 11-09-2007, 11:07 PM |
| You can login to the mysql as root with the following command.
mysql -u root -pPASSWORD
If you need to reset the mysql password follow this step. First command will stop the mysql and the second command starts mysql.
type 'mysql' to enter the mysql prompt and issue the following command to reset the mysql root password.
now restart mysql and enter to mysql prompt as root.
mysql -u root -pnewpassword
|
| Posted by ub3r, 11-09-2007, 11:09 PM |
| You do have a dedicated server, right?
|
| Posted by subnoizerat420, 11-10-2007, 06:44 PM |
| david510: Thanks, it worked. You're great!
ub3r: Yes
|
Add to Favourites 
Print this Article
Also Read
