当前位置:网站首页>A preliminary study of MySQL
A preliminary study of MySQL
2022-07-19 02:46:00 【chip1234】
operating system :ubuntu
1. install MySQL
a. install MySQL Server side 、 Core program commands :sudo apt-get install mysql-server
b. install MySQL Client commands :sudo apt-get install mysql-client
c. Verify that the command is installed and started successfully :sudo netstat -tap | grep mysql
d.( If necessary, ) modify MySQL Profile command :sudo gedit /etc/mysql/my.cnf
2. The development of preparation :
a. open MySql The service command :sudo service mysql start
b. Use root User login command ( The password is empty. ):mysql -u root
b1. The password is not empty :mysql -u root -p


3. New database command
a.( Get into mysql After operation
边栏推荐
- The difference between cookies and sessions
- Uniapp wechat applet login (authorize wechat first and then mobile phone number) - (1)
- 三层交换机配置VLAN和使用OSPF协议
- Dynamic programming problem - Small Soldiers rush forward
- The JMeter BeanShell implementation writes the parameterized data generated by the request to the file
- Expect interaction free
- 2022 latest software testing tools
- The jstat command checks the GC status of the JVM
- 10.系统安全及应用
- MySQL数据库安装
猜你喜欢

Sword finger offer 48 The longest substring without repeated characters

squid代理服务部署

InnoDB, MySQL structure, and the difference between the three kinds of deletion

Leetcode buckle classic topic - 82 Maximum rectangle in column chart

Network layer transmission protocol (detailed)

正则表达式

Getting to know Alibaba cloud environment construction for the first time: unable to connect remotely, and having been in the pit: the server Ping fails, FTP is built, the server builds the database,

学习网络基础

The solution to the bounce and offset of unity3d game characters when jumping to the ground

Metersphere is based on JMeter distributed performance pressure testing platform
随机推荐
Understanding of array and bubbling
"Visual C # from getting started to mastering" personal learning arrangement
The difference between cookies and sessions
JMeter response time test component & multi interface concurrency
Keep two decimal places and take values upward
C语言回调函数 & sprinf 实际应用一例
HCIA第一次静态路由实验
高质量的子程序
MDK Keil/ARM printf 用法说明
Subnet division (see details)
Next array - circular section
For solopi app performance test
[solved] after referring to the local MySQL and forgetting the password, [server] --initialize specified but the data directory has files in it Aborti
The solution to the bounce and offset of unity3d game characters when jumping to the ground
FTP service
Detailed explanation of metauniverse public chain caduceus: a creative platform specially built for metauniverse application
Use of sqlmap
正则、扩展表达式,sed文本处理器与awk工具、用脚本改IP地址
Let's learn about awk~
Shell脚本变量、脚本编写和执行(部署Apache与远程备份MySQL数据库)