Mysql学习

时间:2014-10-19 14:16:27   收藏:0   阅读:216

1.登录mysql,进入mysql bin 目录:

mysql -u root -p

回车后提示输入密码,刚创建完数据库后,root 密码为空,直接回车登录;也可以再登录时指定数据:

mysql -u root dbname -p

2.修改root 用户密码:
方法1:

mysql> set password for ‘root‘@‘localhost‘=password(‘sywu‘);

方法2,直接更新user 表:

mysql> use mysql
Database changed
mysql> update user set password=password(‘sywu‘) where user=‘root‘;
Query OK, 2 rows affected (0.00 sec)
Rows matched: 3  Changed: 2  Warnings: 0

3.查看数据库:

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| cdcol              |
| mysql              |
| performance_schema |
| phpmyadmin         |
| test               |
| webauth            |
| wordpress          |
+--------------------+
8 rows in set (0.00 sec)
4.连接某个数据库:
mysql> use mysql;
Database changed

原文:http://www.cnblogs.com/lanston/p/4034620.html

评论(0
© 2014 bubuko.com 版权所有 - 联系我们:wmxa8@hotmail.com
打开技术之扣,分享程序人生!