mysql密码,默认没有
如果想更改的话, mysqladmin -uroot password root123
登录 : [root@localhost root]# mysql -uroot -proot123
1、创建book数据库
mysql> create database book;Query OK, 1 row affected (0.08 sec)
2、授权给 lili 用户
mysql> grant all on book.* to lili@localhost identified by "lili123";Query OK, 0 rows affected (0.06 sec)
mysql> exit
Bye
3、lili登录
创建lili用户
[root@localhost html]# mysql -u lili -pEnter password: (这里输密码)Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5 to server version: 3.23.54
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>
4、创建book表,添加数据
mysql> use book; (先确定要操作的数据库)
Database changed
5、创建book表
mysql> create table book( -> id int not null, -> name char(20) not null, -> primary key(id) ->);Query OK, 0 rows affected (0.08 sec)
6、添加数据
mysql> insert into book values
-> (1,"语文"), -> (2,"数学"), -> (3,"英语");Query OK, 3 rows affected (0.00 sec)
Records: 3 Duplicates: 0 Warnings: 0
(注意:上面操作也可以用sql语句集来执行: (好处是,去别的机子也可以执行sql语句集 就行,不用从头打过)
[root@localhost html]# cat > lili.sqluse book;
create table book(
id int not null,
name char(20) not null,
primary key(id)
);
insert into book values
(1,"语文",),
(2,"数学"),
(3,"英语");
[root@localhost html]# vi root.sqlcreate database book;
grant all on book.* to lili@localhost identified by "lili123" ;
[root@localhost html]# mysql -u root -p
[root@localhost html]# mysql -u lili -p
)
7、查询表
mysql> select * from book;+----+--------+
| id | name |
+----+--------+
| 1 | 语文 |
| 2 | 数学 |
| 3 | 英语 |
+----+--------+