mysql用户名默认为root(表示最高权限),密码默认为空,忘记时可以重置……(本人使用的是压缩包安装)
目录
登陆mysql
- 打开cmd,进入到mysql中的bin目录,我安装的位置时D盘,progeamFiles文件夹。
C:\Windows\system32>D:
D:\>cd progeamFiles
D:\progeamFiles>cd mysql
D:\progeamFiles\mysql>cd bin
- 输入mysql -uroot -p回车(mysql即mysql.exe,会默认打开exe文件,u:username,p:password,root:默认用户名,密码默认为空。)
D:\progeamFiles\mysql\bin>mysql -uroot -p
Enter password:
若出现Can't connect to MySQL server on localhost (10061)请看下文。
mysql未启动问题
问题描述:在命令行输入 mysql -u root -p 登录mysql,返回”Can't connect to MySQL server on localhost (10061)”错误
- 将mysql加入到Windows的服务中。管理员身份运行cmd,如上进入到mysql的bin目录,命令行运行"mysqld --install"。
D:\progeamFiles\mysql\bin>mysqld --install
Service successfully installed.
- 输入“net start mysql”启动msyql
D:\progeamFiles\mysql\bin>net start mysql
MySQL 服务正在启动 .
MySQL 服务已经启动成功。
- 再次输入“mysql -uroot -p”,登陆成功
D:\progeamFiles\mysql\bin>mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.6.41 MySQL Community Server (GPL)
Copyright (c) 2000, 2018, 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>
配置环境变量
- 此电脑-属性-高级系统设置-环境变量
- 点击下面框的Path,编辑。
- 进入后点击新建,添加mysql中的bin目录。我的目录是D:\progeamFiles\mysql\bin
- 点击确定,再点击确定,直到下面的这个框:
- 然后在cmd可以直接输入mysql登陆了,如果设置了密码,请输入完整的登录信息。
C:\Users\19810>mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.6.41 MySQL Community Server (GPL)
Copyright (c) 2000, 2018, 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>