admin 发表于 2023-1-1 11:25:09

mysql 常用配置

mysqld --initialize --console
mysqld install
net start mysql


mysql -hlocalhost -uroot -p
alter user 'root'@'localhost' identified with mysql_native_password by '123456';
select user,host,plugin,authentication_string from user;
1．WinX或Start-Process powershell -Verb runAs

2．安装MYSQL服务：mysqld –install

3．初始化相关配置：mysqld--initialize   [备注：仅在msyql第一次安装时使用该命令，耗时略长！]

4.启动MYSQL服务：net start mysql

4.停止MYSQL服务：net stop mysql

6.移出mysql服务：mysqld –remove

7.修改root密码：

ALTER USER "root"@"localhost" IDENTIFIED BY "zhuzhong8889";


step1: ALTER USER "root"@"localhost" IDENTIFIED BY "你的新密码";

step2: flush privileges;   FLUSH PRIVILEGES:强制让MySQL重新加载权限，即刻生效！

8.登录mysql mysql -uroot -p

9：常用命令

mysql>showdatabases;       显示所有表

mysql>usemysql;            切换到表mysql      

mysql>showtables;          显示表的结构

services.msc

sourced:/dbname.sql


admin 发表于 2024-3-17 13:46:06

https://www.cnblogs.com/laumians-notes/p/9069498.html
页: [1]
查看完整版本: mysql 常用配置