[MySQL]コマンド
# mysql -uroot -p
(mysql) show databases;
(mysql) create database hoge;
(mysql) create database if not exists hoge;
(mysql) use hoge;
(mysql) select host, user from mysql.user;
+--------+------+
| Host | user |
| localhost | root |
| localhost | zmuser |
+--------+------+
(mysql) set password for zmuser@"localhost"=password('zmpass');
(mysql) show databases;
(mysql) create database hoge;
(mysql) create database if not exists hoge;
(mysql) use hoge;
(mysql) select host, user from mysql.user;
+--------+------+
| Host | user |
| localhost | root |
| localhost | zmuser |
+--------+------+
(mysql) set password for zmuser@"localhost"=password('zmpass');
スポンサーサイト