MySQL安装与管理
A RANDOM PASSWORD HAS BEEN SET FOR THE MySQL root USER !
You will find that password in ‘/root/.mysql_secret‘.
You must change that password on your first connect,
no other statement but ‘SET PASSWORD‘ will be accepted.
See the manual for the semantics of the ‘password expired‘ flag.
一个随机的密码已经生成 可以在 ‘/root/.mysql_secret’. 中找到。第一次连接必须变更密码 且只能使用 ‘SET PASSWORD’ 命令,在user 表中新增加了‘password expired’ 列,也就是密码有效期
mysql -u root -p
xxxxxx(密码是在.mysql_secret)
# The random password set for the root user at Mon Mar 25 11:13:11 2013 (local time): vssAWF0O
Warning: Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 1
Server version: 5.6.10
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.
…………….
Type ‘help;‘ or ‘h‘ for help. Type ‘c‘ to clear the current input statement.
mysql> set password=password(‘123456‘);
Query OK, 0 rows affected (0.00 sec)
mysql> select 1;
+---+
| 1 |
+---+
| 1 |
+---+
1 row in set (0.03 sec)
mysql> CREATE DATABASE [IF NOT EXISTS] db_name
[CHARACTER SET charset_name];
mysql> USE db_name;
mysql> DROP DATABASE db_name;
mysql> CREATE DATABASE db1
CHARACTER SET utf8;
mysql> USE db1;
mysql> DROP DATABASE db1;
mysql> USE mysql;
mysql> GRANT ALL ON db_name.* TO user_name IDENTIFIED BY ‘password‘;
mysql> USE mysql;
mysql> GRANT ALL ON db1.* TO dbuser1 IDENTIFIED BY ‘dbuser1‘;
mysql -u dbuser1 -p
dbuser1
mysql> USE db1;
mysql> SET NAMES utf8;
mysql> source script_name.sql;
郑重声明:本站内容如果来自互联网及其他传播媒体,其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享,并不代表本站赞同其观点和对其真实性负责,也不构成任何其他建议。