mysql 启动 修改密码_mysql启动修改密码

一.mysql 启动方法

1./etc/init.d/mysqld start

2./usr/local/mysql/bin/mysqld_safe --user=mysql &

&:代表后台启动mysql服务

二.mysql 登陆方法:

1.刚装完系统没密码情况:mysql 或者mysql -uroot

2.标准的登陆方法:mysql -uroot -p

3.多实例登陆方法:

mysql -uroot -p -S /data/3306/mysql.sock    #指定下sock文件

mysql -uroot -p -S /data/3307/mysql.sock

三.mysql关闭方法

1.用专门的脚本关闭

四.mysql建用户.并授权方法

1.分2步的方法:

create user [email protected] identified by ‘test11‘;

grant select on mysql.* to [email protected] ;

2.直接一条命令:

mysql> grant select on mysql.* to [email protected] identified by ‘test22‘;

Query OK, 0 rows affected (0.00 sec)

mysql> select user,host from user;

+-----------+-----------+

| user      | host      |

+-----------+-----------+

| root      | 127.0.0.1 |

| root      | localhost |

| test      | localhost |

| test2     | localhost |

| wordpress | localhost |

+-----------+-----------+

5 rows in set (0.00 sec)

五.mysql修改密码方法:

1.安装完后,设置密码方法:

a.mysqladmin -uroot -password  ‘test88‘

b.mysqladmin -uroot -password  ‘test88‘ -S    /data/3306/mysql.sock     #多实例的例子

2.修改密码

a. [[email protected]~]# mysqladmin -uroot -p‘mybaby99‘ password ‘ainini99‘

b. [[email protected]~]# mysqladmin -uroot -p‘mybaby99‘ password ‘ainini99‘ -S /data/3306/mysql.sock

六.找回丢失密码:

1.单实例

[[email protected] ~]# killall mysqld

[[email protected] ~]# mysqld_safe --skip-grant-table & mysql -uroot -p

mysql> use mysql;

Database changed

mysql> update user set password=password(‘mygirl99‘) where user=‘root‘;

Query OK, 2 rows affected (0.00 sec)

Rows matched: 2  Changed: 2  Warnings: 0

mysql> flush privileges;

Query OK, 0 rows affected (0.00 sec)

你可能还对mysql编译参数查看的相关内容感兴趣

原文：http://txidc.blog.51cto.com/9138217/1567817