环境:从官网下载的rpm包:MySQL-server-advanced-5.6.26-1.el6.x86_64.rpmmysql
安装在Linux。sql
安装以后,链接数据库,使用命令:mysql -uroot -p数据库
有的mysql安装后默认密码为空,不用输入密码,直接回车就能够进到数据库中。进去以后再改密码,而后正常使用。spa
可是也有有密码,殊不知道密码是什么的。server
这时候就须要查看一个文件:/root/.mysql_secret。安装mysql数据库以后,密码默认写在这个文件中。blog
登陆时使用这个密码便可。ci
以下图:input
知道密码,就能够链接数据库了:it
[root@MySQL-SQL1 mysqlmedia]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 6
Server version: 5.6.24-ndb-7.4.6-cluster-commercial-advanced
Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> set password for 'root'@'localhost'=password('root');
Query OK, 0 rows affected (0.01 sec)
记得链接上以后须要当即修改root用户密码才能使用的。io
不然将收到以下报错:
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'database' at line 1。