 |
| Who's Online | |
There are currently, 0 guest(s) and 0 member(s) that are online.
You are Anonymous user. You can register for free by clicking here | |
| Login | |
|
Don't have an account yet? You can create one. As a registered user you have some advantages like theme manager, comments configuration and post comments with your name. | |
| |
 | Change root password on MySQL |
 To change root password, follow directions below:
1. Log into MySQL shell as usual.
2. Type "use mysql;" to change to mysql database
3. Type "UPDATE user SET password=password('newpassword') WHERE user='root';
4. Type "flush privileges;"
|
|
|
Posted by abb on Tuesday, March 07 @ 15:45:37 EST (2191 reads)
(Read More... | 40 comments | Score: 0)
|
|
|
| Setup MySQL password for the first time |
After you've installed MySQL, you should go ahead and setup password for security purpose. The command to do so is as followed:
mysqladmin -u root -p password 'new-password'
|
|
|
Posted by abb on Tuesday, March 07 @ 15:31:31 EST (4301 reads)
(Read More... | 555 comments | Score: 5)
|
|
|
| Grant privilege to a user for a specific database |
To grant access to a specific user to a specific database, type the following MySQL statement:
grant all on DatabaseName.* to user@localhost identified by 'password';
|
|
|
Posted by abb on Tuesday, March 07 @ 15:29:00 EST (2960 reads)
(Read More... | 237 comments | Score: 0)
|
|
| |
|
|
