Lägg till en ny användare, med rätt privilegier

• Logga in som root
• Skapa användare
• Sätta behörighet
• Skapa databas
• Skapa tabeller

1. Skapa ett rootkonto

   Admin user id: root
       Default password: blankt
       

   Det första man gör, är att skapa ett lösenord:

    [prompt]$ mysqladmin -u root password 'lösenord'
         Notera: att följande SQL kommando även fungerar:
   

   • mysql> USE mysql;
   • mysql> UPDATE user SET Password=PASSWORD('lösenord') WHERE user='root';
   • mysql> FLUSH PRIVILEGES;

   Logga in, skapa användare, sätta behörighet (OBS! Över nätverk)

   [prompt]$mysql -h localhost -u root -p login:
   • mysql> INSERT INTO user (Host, User, Password, Select_priv) VALUES ('', 'jensa', password('lösenordet'), 'Y');
   • mysql> FLUSH PRIVILEGES;
   • mysql> UPDATE user SET Host='%' WHERE User='jensa';
   • mysql> FLUSH PRIVILEGES;
   • mysql> GRANT ALL PRIVILEGES ON dacke. * TO jensa@'%';

   Kontrollera att det stämmer

   mysql> SELECT User,Password,Host FROM user WHERE User='jensa';

   Att ta bort en användare

   • mysql> use mysql;
   • mysql> SELECT DATABASE();
   • mysql> SHOW TABLES;
   • mysql> SELECT User,Password,Host FROM user;
   • mysql> DELETE FROM user WHERE User='jensa';
   • mysql> FLUSH PRIVILEGES;

[prompt]$ mysqladmin -h localhost -u root -ppassword create dacke
    
   (eller använd SQL kommando: CREATE DATABASE dacke;) 
   

 [prompt]$mysql -h localhost -u root -p  
 
 mysql> use dacke;
 
 mysql> create table members (Namn char(20),Avd char(20),Befattn char(20));
 
 mysql> DESCRIBE members;
+----------+----------+------+-----+---------+-------+
| Field    | Type     | Null | Key | Default | Extra |
+----------+----------+------+-----+---------+-------+
| Namn     | char(20) | YES  |     | NULL    |       |
| Avd      | char(20) | YES  |     | NULL    |       |
| Befattn  | char(20) | YES  |     | NULL    |       |
+----------+----------+------+-----+---------+-------+
3 rows in set (0.03 sec)
 

mysql> SELECT User,Password,Host from user;
+-------+------------------+-----------+
| User  | Password         | Host      |
+-------+------------------+-----------+
| root  | 60376a56019a2a1f | localhost |
| jensa | 551d42253e79a26d | %         |
+-------+------------------+-----------+
4 rows in set (0.00 sec)
mysql> DELETE FROM user WHERE User='jensa';
Query OK, 1 row affected (0.01 sec)

mysql>FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

mysql> SELECT User,Password,Host from user;
+------+------------------+-----------+
| User | Password         | Host      |
+------+------------------+-----------+
| root | 60376a56019a2a1f | localhost |
+------+------------------+-----------+
1 row in set (0.01 sec)

 

Slackware Linux is a Registered Trademark of Patrick J. Volkerding (Slackware inc.).
Linux i a Registered Trademark of Linus Torvalds.
(Legal Notice)