安裝MySQL數據庫
~ $ emerge -av mysql
登錄報錯
mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: YES)'
解決方法： mysqld_safe --user=mysql --skip-grant-tables --skip-networking&
mysql -u root mysql mysql> update user set password=PASSWORD(103545) where user='root'; Query OK, 3 rows affected (0.00 sec) Rows matched: 3 Changed: 3 Warnings: 0 mysql> flush privileges; Query OK, 0 rows affected (0.00 sec) mysql> exit Bye brightmoon dotproject # mysql -u root -p /etc/init.d/mysql restart即可
修改root密碼并登錄數據庫
~ $ mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 6 Server version: 5.1.66-log Gentoo Linux mysql-5.1.66 Copyright (c) 2000, 2012, 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> SHOW DATABASES; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | test | +--------------------+ 3 rows in set (0.00 sec) mysql> CREATE DATABASE gentoo; Query OK, 1 row affected (0.00 sec) mysql> SHOW DATABASES; +--------------------+ | Database | +--------------------+ | information_schema | | gentoo | | mysql | | test | +--------------------+ 4 rows in set (0.00 sec)
使用gentoo數據庫，并創建示例
mysql> USE gentoo;
Database changed
mysql> CREATE TABLE developers ( name VARCHAR(128), email VARCHAR(128), job VARCHAR(128));
Query OK, 0 rows affected (0.13 sec)
mysql> SHOW TABLES;
+------------------+
| Tables_in_gentoo |
+------------------+
| developers |
+------------------+
1 row in set (0.00 sec)
mysql> DESCRIBE developers;
+-------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+--------------+------+-----+---------+-------+
| name | varchar(128) | YES | | NULL | |
| email | varchar(128) | YES | | NULL | |
| job | varchar(128) | YES | | NULL | |
+-------+--------------+------+-----+---------+-------+
3 rows in set (0.00 sec)
mysql> INSERT INTO developers VALUES('Merlyn Chen', 'merlyncaulfield@gmail.com', 'toolchain');
Query OK, 1 row affected (0.00 sec)
mysql> INSERT INTO developers (job, name) VALUES('outsourced', 'Jane Doe');
Query OK, 1 row affected (0.00 sec)
mysql> DESCRIBE developers;
+-------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+--------------+------+-----+---------+-------+
| name | varchar(128) | YES | | NULL | |
| email | varchar(128) | YES | | NULL | |
| job | varchar(128) | YES | | NULL | |
+-------+--------------+------+-----+---------+-------+
3 rows in set (0.00 sec)
查看用戶
mysql> select User,Host from mysql.user; +--------------+------------+ | User | Host | +--------------+------------+ | root | 127.0.0.1 | | | brightmoon | | root | brightmoon | | | localhost | | FreeSMonitor | localhost | | power_admin | localhost | | poweradmin | localhost | | powerdns | localhost | | root | localhost | +--------------+------------+ mysql> show grants for root@brightmoon; +----------------------------------------------------------------------+ | Grants for root@brightmoon | +----------------------------------------------------------------------+ | GRANT ALL PRIVILEGES ON *.* TO 'root'@'brightmoon' WITH GRANT OPTION | +----------------------------------------------------------------------+ 1 row in set (0.00 sec) mysql> show grants for FreeSMonitor@brightmoon; ERROR 1141 (42000): There is no such grant defined for user 'FreeSMonitor' on host 'brightmoon' mysql> show grants for FreeSMonitor@localhost; +---------------------------------------------------------------------------------------------------------------------+ | Grants for FreeSMonitor@localhost | +---------------------------------------------------------------------------------------------------------------------+ | GRANT USAGE ON *.* TO 'FreeSMonitor'@'localhost' IDENTIFIED BY PASSWORD '*2A032F7C5BA932872F0F045E0CF6B53CF702F2C5' | | GRANT ALL PRIVILEGES ON `nms_v3`.* TO 'FreeSMonitor'@'localhost' | +---------------------------------------------------------------------------------------------------------------------+ 2 rows in set (0.00 sec)