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)