Mysql root იუზერზე პაროლის გამართვა
[cc lang=’bash’ ]/usr/bin/mysqladmin -u root password ‘kirkita'[/cc]
mysql-ში შესვლა (მაგ: user: root password: kirkita)
[cc lang=’bash’ ]mysql -u root -pkirkita[/cc]
kirkita იუზერის შექმნაjupiter.connect.ge
[cc lang=’mysql’ ]mysql> CREATE USER ‘kirkita’@’192.168.0.205’ IDENTIFIED BY ‘kirkita’;
mysql> GRANT ALL PRIVILEGES ON *.* TO ‘kirkita’@’192.168.0.205′ WITH GRANT OPTION;[/cc]
[cc lang=’mysql’ ]mysql> CREATE USER ‘kirkita’@’localhost’ IDENTIFIED BY ‘kirkita’;
mysql> GRANT ALL PRIVILEGES ON *.* TO ‘kirkita’@’localhost’ WITH GRANT OPTION;[/cc]
შედეგების ნახვა
[cc lang=’mysql’ ]mysql> select host, user, password from mysql.user;
+—————+———+——————+
| host | user | password |
+—————+———+——————+
| localhost | root | 50d2103d7835124c |
| 127.0.0.1 | root | |
| localhost | | |
| 192.168.0.205 | kirkita | 50d2103d7835124c |
| localhost | kirkita | 50d2103d7835124c |
+—————+———+——————+[/cc]
Mysql-ის აჩქარება
[cc lang=’mysql’]skip-locking
skip-name-resolve[/cc]
