错误:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
解决:
这种问题需要强行重新修改密码,方法如下:
/etc/init.d/mysql stop (service mysqld stop )
/usr/bin/mysqld_safe --skip-grant-tables
再开一个terminal:
[root@localhost ~]# mysql
mysql>use mysql
mysql>update user set password=password("123456") where user="root";
mysql>flush privileges;
mysql>exit
另附mysql安装和操作文档:
mysql 安装:
http://jingyan.baidu.com/article/425e69e6bbc6c7be14fc1640.html
1. apt-get install mysql-server mysql-client
2. 让apache支持mysql:
apt-get install libapache2-mod-auth-mysql
3. 让php支持mysql
apt-get install php5-mysql
4. 重启mysql:
service mysql restart
5. 登录mysql:
mysql -p
mysql使用:
1. 启动mysql:
/etc/init.d/mysql start
2. log in mysql:
mysql -p
3. 查看所有数据库:
show databases;
4. 创建数据库(sanshanxyz):
create databases sanshanxyz;
5. 进入数据库sanshanxyz(选择一个数据库进入):
use sanshanxyz;
6. 创建表baozi:
create table baozi(id INT AUTO_INCREMENT PRIMARY,name varchar(20) NOT NULL);
7. 往表里插入数据
insert into baozi(name) values('朱磊');
8. 显示baozi中的字段及一些非空信息
desc baozi;
9. 查表:
select * from baozi;
10. log out mysql数据库:
quit
11. 关闭mysql数据库:
/etc/init.d/mysql stop