Debian学习手迹-安装Mysql简单方法

写给自己看的,高手别笑话:-)

两个命令:

# apt-get install mysql-server-4.1
# apt-get install phpmyadmin

这样安装之后,默认通过http://IP/phpmyadmin没法访问,会提示:

#1045 - Access denied for user ‘root’@'localhost’ (using password: YES)

在shell内执行:

# mysql
grant all on *.* to root@localhost identified by “password”;
注释:

grant 分配权限
all 所有权限
on *.* 在所有数据库上
to root@localhost 给通过本地连接的root账户
identified by “password” 密码为password
; 执行标志

No comments yet.

Write a comment: