Home Database Mysql Tutorial mysql学习与整理常用知识

mysql学习与整理常用知识

Jun 07, 2016 pm 03:46 PM
mysql study Commonly used tidy local Knowledge

最近在本地装了一个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与后面的密码不能有空格)



Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot Article Tags

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

PHP's big data structure processing skills PHP's big data structure processing skills May 08, 2024 am 10:24 AM

PHP's big data structure processing skills

How to optimize MySQL query performance in PHP? How to optimize MySQL query performance in PHP? Jun 03, 2024 pm 08:11 PM

How to optimize MySQL query performance in PHP?

How to use MySQL backup and restore in PHP? How to use MySQL backup and restore in PHP? Jun 03, 2024 pm 12:19 PM

How to use MySQL backup and restore in PHP?

How to insert data into a MySQL table using PHP? How to insert data into a MySQL table using PHP? Jun 02, 2024 pm 02:26 PM

How to insert data into a MySQL table using PHP?

What are the application scenarios of Java enumeration types in databases? What are the application scenarios of Java enumeration types in databases? May 05, 2024 am 09:06 AM

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 fix mysql_native_password not loaded errors on MySQL 8.4 Dec 09, 2024 am 11:42 AM

How to fix mysql_native_password not loaded errors on MySQL 8.4

How to use MySQL stored procedures in PHP? How to use MySQL stored procedures in PHP? Jun 02, 2024 pm 02:13 PM

How to use MySQL stored procedures in PHP?

How to create a MySQL table using PHP? How to create a MySQL table using PHP? Jun 04, 2024 pm 01:57 PM

How to create a MySQL table using PHP?

See all articles