mysql 常用配置

admin

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

my.ini (4.8 KB, 下载次数: 13)

2024-3-17 13:29 上传

点击文件名下载附件

mysql-几种场景的配置.rar (19.97 KB, 下载次数: 12)

2024-3-17 13:32 上传

点击文件名下载附件

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[newpassword]

9：常用命令

mysql>showdatabases;       显示所有表

mysql>usemysql;            切换到表mysql        

mysql>showtables;          显示表的结构

services.msc

sourced:/dbname.sql

admin

https://www.cnblogs.com/laumians-notes/p/9069498.html