mysql安装使用问题记录

安装问题

windows10安装mysql5.8，运行net mysql start，提示服务启动失败
1、将c:\mysql\bin加入系统环境变量中
2、my.ini

[mysqld]
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M

# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin

# These are commonly set, remove the # and set as required.
basedir = D:\mysql
datadir = D:\mysql\data
port = 3306
# server_id = .....

default_authentication_plugin=mysql_native_password

# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M 

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES 

character-set-server = utf8mb4

performance_schema_max_table_instances = 600
table_definition_cache = 400
table_open_cache = 256

[mysql]
default-character-set = utf8mb4

[client]
default-character-set = utf8mb4

3、使用管理员身份打开cmd.exe，切换目录到c:\mysql\bin下
mysqld --initialize --console 初始化mysql
下图中的localhost后跟的是密码，这是初始密码，牢记住在这里插入图片描述
运行顺序
mysqld --initialize --console 初始化mysql
mysqld install 安装mysql服务
net start mysql 启动mysql

使用问题

InnoDB: Error: Table “mysql”.“innodb_table_stats” not found.
删除过ibdata1又找不到备份的情况下，使用下面的解决办法，如果没有的话，应该有更简单的方法

  1. mysql database这个库中还有这个表，但是删除innodb_table_stats的时候一直报错，在data/mysql 下删除innodb_table_stats，再去执行drop table nnodb_index_stats;
  2. 这5个表的sql语句打开这个链接 http://bugs.mysql.com/file.php?id=19725 下载
  3. 删除之后执行这5个sql语句创建表
    可以安照这个步骤解决：
    https://blog.51cto.com/lvjuntao/2060141