our approach|contact us

MySQL Basics In Pictures

• Starting
• Administration
• Tables
• Queries
• Security
• Web

Add a local user

1. Open a terminal window.
2. Connect to the MySQL server using your root MySQL password and go to the mysql database within it:
   mysql -u root -p mysql
3. At the mysql> prompt, type:
   GRANT ALL PRIVILEGES ON *.* TO mary@localhost IDENTIFIED BY 'ship3marker';
   then press ENTER.
   This command string creates a new account on the MySQL server for the user mary. Her password is ship3marker.