Online computer courses, code, programming tutorial and sidebar information for monitoring Canadian S&P/TSX index. Build friendship and networking. Welcome to visit my blogs often!!! I also have two other sites: YouTube Channel and Google site.
Adsense
Popular Posts
- PHPWind-- A PHP forum script applcaition in China
- Using Cron Job to process PHP scripts
- job interview questions (1)
- PHP connect IBM db2 database in XAMPP
- Set up a child account and set screen time limit in Windows 8
- Datatable export excel wraptext and newline
- Install PHPMailer 5.2.4 and use smtp gmail
- PHP - Export Content to MS Word document
- Powerful js library datable to export table in pdf, excel, sorting, freezing column and table header fixed (sticky)
- Sweet Alert JS library - beautiful replacement of JavaScript Alert
Thursday, November 21, 2013
Create a New User with same privileges as root in MYSQL
Sometimes we may need to create a new user with same privileges as root in MYSQL in case we forget the root password.
To create a new user jianse in MySQL with password "mypass"
CREATE USER 'jiansen'@'localhost' IDENTIFIED BY 'mypass';
Sets all simple privileges except GRANT OPTION to new user jiansen
GRANT ALL PRIVILEGES ON * . * TO 'jiansen'@'localhost';
Add GRANT OPTION to new user jiansen
GRANT GRANT OPTION ON * . * TO 'jiansen'@'localhost';
Now user jiansen has same rigth as root in MySQL.
Reference:
Crack mysql root password in several ways
http://www.sureshkumarpakalapati.in/2011/07/crack-mysql-root-password-in-several.html
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment