Differences

This shows you the differences between two versions of the page.

Link to this comparison view

mysqladduser [2016/01/10 15:16] (current)
yassine chaouche created
Line 1: Line 1:
  
 +\\
 +[[index|Home]] > [[computers|computers]] >  [[databases]] > [[mysql|mysql]] > [[MysqlAddUser|MysqlAddUser]]| [[About]]
 +
 +
 +<code>
 +root@karabeela /home/chaouche/DOCUMENTS/BOULOT/CV/CUSTOM/RADIO # mysql  -p
 +Enter password:
 +Welcome to the MySQL monitor.  Commands end with ; or \g.
 +Your MySQL connection id is 16
 +Server version: 5.5.23 Mageia  - MySQL Community Edition (GPL)
 +
 +Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.
 +
 +Oracle is a registered trademark of Oracle Corporation and/or its
 +affiliates. Other names may be trademarks of their respective
 +owners.
 +
 +Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
 +
 +mysql> use mysql
 +Database changed
 +mysql> CREATE USER 'ychaouche'@'localhost' IDENTIFIED BY 'plaintextpassword';
 +Query OK, 0 rows affected (0.07 sec)
 +
 +mysql> select user from user;
 ++-----------+
 +| user      |
 ++-----------+
 +| root      |
 +| root      |
 +|           |
 +| root      |
 +|           |
 +| root      |
 +| ychaouche |
 ++-----------+
 +7 rows in set (0.02 sec)
 +
 +mysql>
 +
 +</code>
 +
 +Allow user to create databases and tables as well as deleting them
 +
 +<code>
 +mysql> GRANT ALL ON  *.* TO 'ychaouche'@'localhost';
 +Query OK, 0 rows affected (0.00 sec)
 +mysql>
 +</code>
 +
 +----
 +
 +contact : [[http://twitter.com/ychaouche|@ychaouche]] yacinechaouche at yahoocom

QR Code
QR Code mysqladduser (generated for current page)