FreeBSD - Tutorials, Security
Home   Archives   Sitemap   About   Contact

How to set up a password for root user in MySql

Home NEW! Unix Forum News 100 Tips and Tricks Website Development Server Operating Systems Databases
 Ivorde.ROarrow Databases arrowSecurity and BackuparrowHow to set up a password for root user in MySql 

Article Sections

    Hello, Guest !
User name:
Password:
 
Google

 SSD VPS Hosting - Vpsie.com
 Mo.nitor.me
 Ivorde forum
 FreeBSD Tutorials
 Linux LVM Commands
 Free Shell Accounts
 FreeBSD Project
 FreeBSD Handbook
 Advanced Bash-Scripting Guide
 The OpenBSD Project
 Distrowatch
 FreeBSD Handbook


Apache Webserver Home Page

Posted on: 12 Dec 2007
Author: mandrei
Section: Databases | Security and Backup
Views: 548
Comments: 0 (Add)

How to set up a password for root user in MySql
Setting MySql root password

 



By default, MySql comes with no password for localhost root user and with access to the console, any could have access to all databases also.

Set MySql root password:

$ mysqladmin -u root password newpassword


Replace "newpassword" with your new password (and make sure you remember it).

From now on, mysql will deny access to the database unless you provide -p argument to mysql command at the shell prompt.

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

It will request from you the password when connecting to the database. To connect to the mysql database with your new password, issue the following command:

$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 553
Server version: 5.1.20-beta-log FreeBSD port: mysql-server-5.1.20

Type 'help;' or 'h' for help. Type 'c' to clear the buffer.

mysql>

Now you have your database protected against local unauthorized people.

Change MySql root password:

Now that you have a password for mysql root user and you need to change it (doesn't work with mysqladmin -u root oldpass new pass, at least for me it didn't work).

Login as root and root password to mysql database:

$ mysql -u root -p mysql
Enter password:
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 581
Server version: 5.1.20-beta-log FreeBSD port: mysql-server-5.1.20

Type 'help;' or 'h' for help. Type 'c' to clear the buffer.

mysql> set password for root@localhost=PASSWORD('hondad16z6');
Query OK, 0 rows affected (0.00 sec)

mysql> SET PASSWORD FOR root@localhost=PASSWORD('newpassword');
mysql> Bye

And now log back in with root user and newpassword. There you have it :).
Bookmarks: Echo "How to set up a password for root user in MySql" around:
del.icio.usdiggFurlYahooMyWebGoogleBookmarksFaceBookTechnocratti
-------------------advertising-----------------

Other articles in Databases / Security and Backup
» Recover a lost MySQL root password
» How to copy a mysql database using mysqldump
» How to backup all mysql databases with one command
» MySQL table - change or rename MySql table name
» How to calculate difference in days between two dates in MySQL




Contact webmaster regarding this article
Register or Login to post your article
Hello, Guest ! You can Login or Register to www.ivorde.ro!

 Post comment:

Name:
Title:
Comment:
Please type the word you see in the image (anti-spam verification). Refresh the page if you don't understand the word.
Allowed HTML Tags for comments:<p><strong><em><u><h1><h2><h3><h4><h5><h6><img><li>
<ol><ul><span><div><br><ins><del>

0 comment(s) to How to set up a password for root user in MySql:

   Latest topics on the forum:
 
   Most viewed articles:
How to copy a mysql database using mysqldump - 9376 views
How to change a user's password in AIX with the output from ECHO command - 8635 views
FreeBSD: Add/remove an additional IP alias - 5609 views
Qmail relay to smarthost: How to route all mail to a smarthost - 3929 views
Print queues in AIX 5L - How to list print queues in AIX - 2884 views

   Latest 10 articles:
Qmail relay to smarthost: How to route all mail to a smarthost - 03 Feb 2009
EXIM 4 relay to smarthost: How to route all mail except local domain - 03 Feb 2009
Windows XP: print LISTEN ports and network connections using netstat - 30 Jan 2009
How to cut out first last n characters from each file name, from a filelist - 04 Nov 2008
Mozilla Firefox3 is now released - 18 Jun 2008
How to switch lower case to upper case and upper case to lower case in a string - 17 Jun 2008
How to rename files/directories to uppercase/lowercase character names - 17 Jun 2008
How to convert lower case to upper case letters in a shell script/command - 17 Jun 2008
Unix,Linux,FreeBSD - How to rename a list of files, replacing spaces inside their names - 12 Jun 2008
How to change a user's password in AIX with the output from ECHO command - 21 May 2008


Archives
» 2007  |  June  |  October  |  November  |  December
» 2008  |  January  |  February  |  March  |  April  |  May  |  June  |  November
» 2009  |  January  |  February



Home | Archives | Sitemap | About | Contact

Designed and developed by Andrei Manescu. Optimized for Mozilla Firefox.  
Copyright 2007 Andrei Manescu
All trademarks and copyrights on this page are owned by their respective owners. Comments are owned by those who posted them.
Valid W3 Document Valid XHTML 1.0 Transitional Valid CSS! The FreeBSD Project Viewable With Any Browser