mysqlのコマンド

Login

$ mysql -u root -p database_name;
$ exit

Database

mysql> show databases;
mysql> user database;
mysql> create database database_name;
mysql> remove database database_name;
$ mysqldump -u username database_name > dump.sql
$ mysql -u username -p password -D database_name < dump.sql

Table

mysql> show tables from database;
mysql> show indexes from table;
mysql> create table users (
  id int not null auto_increment primary key
  name varchar(255)
  email varchar(255) 
);
mysql> insert users into (
  name, email
) values (
  'sample', 'sample@sample.com'
);
mysql> select * from users
where like '%sample.com' limit 10 order by id desc;
mysql> update database_name.users set name = 'updated_name'
where email = 'sample@sample.com';
mysql> delete from users where id = '1';

User

mysql> select host, user, password from mysql.user;
mysql> create user 'sample'@'localhost` identified by 'password';
mysql> select password('password');
mysql> set password for 'sample'@'localhost' = '*2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19';
mysql> grant all on database_name.* to 'sample'@'localhost';
mysql> show grants for 'sample'@'localhost';

MysqlAdmin

$ mysqladmin -u root -p create database_name;
$ mysqladmin -u root -p drop database_name;
$ mysqladmin -u root -p flush-privileges;
$ mysqladmin -u root -p status;
$ mysqladmin -u root -p password password;