mysql学习与整理常用知识
Jun 07, 2016 pm 03:46 PM最近在本地装了一个mysql数据库, 一: 在本地启动、关闭mysql服务器的两种方法 方便自己以后应用。 1.从“控制面板”“管理工具”中找到“服务”选项,在“名称”列中找到“MySQL”服务,单击右键, 选择启动或者停止 2.在命令行cmd下, 启动: C:\Document
最近在本地装了一个mysql数据库,
一:在本地启动、关闭mysql服务器的两种方法
方便自己以后应用。
1.从“控制面板”“管理工具”中找到“服务”选项,在“名称”列中找到“MySQL”服务,单击右键,
选择启动或者停止
2.在命令行cmd下,
启动:
C:\Documents and Settings\Administrator>net start mysql
停止:
C:\Documents and Settings\Administrator>net stop mysql
二:命令行连接mysql数据库
步骤一:打开命令窗口,cd到mysql的安装目录,比如:C:\ProgramFiles\MySQL\MySQL Server 5.5\bin下,如果mysql在本地配置了环境变量的话,省略此步骤。
步骤二:执行命令mysql-u root -p 回车,如果有密码的话,需要执行mysql-u root -p123 (注意-p与后面的密码不能有空格)

Hot Article

Hot tools Tags

Hot Article

Hot Article Tags

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

PHP's big data structure processing skills

How to optimize MySQL query performance in PHP?

How to use MySQL backup and restore in PHP?

How to insert data into a MySQL table using PHP?

What are the application scenarios of Java enumeration types in databases?

How to fix mysql_native_password not loaded errors on MySQL 8.4

How to use MySQL stored procedures in PHP?

How to create a MySQL table using PHP?
