Creating users in mysql

root@chilibeans:~# mysql -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 4023 to server version: 3.23.54

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

mysql> create database queze;
Query OK, 1 row affected (0.03 sec)

mysql> grant all privileges on queze.* to queze@localhost identified by "*****";
Query OK, 0 rows affected (0.01 sec)

 

Dette indlæg blev udgivet i Knowledge Base, Old Base, SQL. Bogmærk permalinket.

Skriv et svar