Linux运维必会的100道MySql面试题之（一）

 /etc/init.d/mysqld start
 service mysqld start

 sysctl  start mysqld

 lsof -i :3306
 netstat -lntup |grep 3306

mysql -uroot -ppassword -e "set passowrd for root = passowrd('passowrd')"
mysqladmin -uroot passowrd "NEWPASSWORD"

mysqladmin -uroot passowrd oldpassowrd "NEWPASSWORD"
use mysql;
update user set passowrd = PASSWORD('newpassword') where user = 'root';flush privileges;

alter user 'root'@'localhost' identified by 'root' 

 mysql -uroot -ppassword

show create database DB_NAME;

mysql -V
mysql -uroot -ppassowrd -e "use mysql;select version();"

mysql -uroot -ppassowrd -e "select user();"

select user();  #进入数据库查询

create database mingongge default charset gbk collate gbk_chinese_ci;

grant all on mingongge.* to 'mingongge'@'localhost' identified by 'mingongge';

show grants for mingongge@localhost;

select user from mysql.user;

create table test (
  id int(4),
  name varchar(16)
 )ENGINE=innodb DEFAULT CHARSET=gbk;

desc test;
show create table test\G

insert into test values('1','mingongge');

insert into test values('2','民工哥'),('3','mingonggeedu');

select * from test where name = 'mingongge';

update test set name = 'mgg' where id = '1';

alter table test add age tinyint(2) after id;

system mysqldump -uroot -ppassword -B mingongge >/root/mingongge_bak.sql