当前位置: 技术问答>linux和unix
LINUX上的MYSQL问题
来源: 互联网 发布时间:2015-12-27
本文导语: # mysql Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 6 to server version: 4.1.11-standard Type 'help;' or 'h' for help. Type 'c' to clear the buffer. mysql> show databases -> create database 'text' ...
# mysql
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 6 to server version: 4.1.11-standard
Type 'help;' or 'h' for help. Type 'c' to clear the buffer.
mysql> show databases
-> create database 'text'
-> show database
-> c
mysql> exit
Bye
# mysqladmin -u root -p password '123456'
Enter password:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'
问题是数据库好象一点反映都没有。不知道是什么问题!!
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 6 to server version: 4.1.11-standard
Type 'help;' or 'h' for help. Type 'c' to clear the buffer.
mysql> show databases
-> create database 'text'
-> show database
-> c
mysql> exit
Bye
# mysqladmin -u root -p password '123456'
Enter password:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'
问题是数据库好象一点反映都没有。不知道是什么问题!!
|
加个";"再回车,比如:
show databases;
show tables;
show databases;
show tables;
|
mysqladmin -u root -p password '123456'不用 -P了 就
你的密码还是没改过来 还是以前的
你先前的数据库没密码吧
你的密码还是没改过来 还是以前的
你先前的数据库没密码吧
|
对,不需要 -p , password 已经是了
还有,要想密码马上生效,要重启
还有,要想密码马上生效,要重启