blocks|key|249120|text|如果您仍然能够登录(我假设您不能登录，因为没有用户表)，并且有要保存的数据库，请使用|type|unstyled|depth|inlineStyleRanges|entityRanges|data|249121|mysqldump+--routines+databasename+>+outfile.sql|code-block|syntax|javascript|249122|可以使用以下命令重新创建MySQL数据库|249123|#+Most+MySQL+versions
mysql_install_db

#+MySQL+5.7+and+later
mysqld+--initialize|249124|MySQL+Documentation+here|offset|length|249125|entityMap|0|LINK|mutability|MUTABLE|url|http://dev.mysql.com/doc/refman/5.0/en/mysql-install-db.html^0|0|0|0|0|0|O|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|X|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Y|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|Z|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|10|8|@]|9|@$M|11|N|12|1|13]]|A|$]]|$1|O|3|-4|5|6|7|14|8|@]|9|@]|A|$]]]|P|$Q|$5|R|S|T|A|$U|V]]]]

If you are still able to log in (I assume you aren't since there's no user table) and have databases to save, dump them with 

<pre><code>mysqldump --routines databasename &gt; outfile.sql
</code></pre>

The MySQL database can be recreated with the command

<pre><code># Most MySQL versions
mysql_install_db

# MySQL 5.7 and later
mysqld --initialize
</code></pre>

<a href="http://dev.mysql.com/doc/refman/5.0/en/mysql-install-db.html" rel="noreferrer">MySQL Documentation here</a>

blocks|key|1374127|text|有关更多信息，请访问：https://dev.mysql.com/doc/refman/5.7/en/data-directory-initialization.html|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1374128|在Windows上，使用以下命令之一：|1374129|C:\>+bin\mysqld+--initialize
C:\>+bin\mysqld+--initialize-insecure|code-block|syntax|javascript|1374130|entityMap|0|LINK|mutability|MUTABLE|url|https://dev.mysql.com/doc/refman/5.7/en/data-directory-initialization.html^0|B|22|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@$A|T|B|U|1|V]]|C|$]]|$1|D|3|E|5|6|7|W|8|@]|9|@]|C|$]]|$1|F|3|G|5|H|7|X|8|@]|9|@]|C|$I|J]]|$1|K|3|-4|5|6|7|Y|8|@]|9|@]|C|$]]]|L|$M|$5|N|O|P|C|$Q|R]]]]

read more at: <a href="https://dev.mysql.com/doc/refman/5.7/en/data-directory-initialization.html" rel="nofollow noreferrer">https://dev.mysql.com/doc/refman/5.7/en/data-directory-initialization.html</a>

On Windows, use one of these commands:

<pre><code>C:\&gt; bin\mysqld --initialize
C:\&gt; bin\mysqld --initialize-insecure
</code></pre>

blocks|key|249300|text|我最近安装了MySQL8，mysql默认数据库似乎有问题。不管怎么说，这对我很有效：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|249301|mysql_upgrade+-u+root+-p|code-block|syntax|javascript|249302|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

I recently installed mysql 8 and it seemed that there was a problem with mysql default databases.
Anyway, this worked for me :

<pre><code>mysql_upgrade -u root -p
</code></pre>

blocks|key|249268|text|我无意中删除了数据库mysql，而mysqld+--initialize也帮不了我。没有显示错误，甚至mysql服务启动正常，但文件夹mysql没有创建，mysql不可用-我甚至无法创建新的数据库。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|249269|在花了很多时间尝试不同的选项之后，我注意到我已经弃用了选项innodb_additional_mem_pool_size=20M，它会使mysqld+--initialize崩溃|249270|修复mysql配置后，它工作得很好。|249271|entityMap^0|H|J|0|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@$9|M|A|N|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|O|8|@]|D|@]|E|$]]|$1|H|3|I|5|6|7|P|8|@]|D|@]|E|$]]|$1|J|3|-4|5|6|7|Q|8|@]|D|@]|E|$]]]|K|$]]

I removed database mysql by accident and mysqld --initialize didnt helped me.
No errors showed, even mysql service started OK, but folder mysql wasnt created and mysql wasnt usable - I wasnt able even to create new databases.

After spending a lot of time on trying different options I noticed, that I have deprecated option innodb_additional_mem_pool_size=20M, which crashed mysqld --initialize

After fixing mysql config - it worked well.

blocks|key|356629|text|我有这样的错误：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|356630|root@ubuntu-2gb-nbg1-1+~+#+mysqld+--initialize
2019-01-23T15:11:22.428139Z+0+[Warning]+TIMESTAMP+with+implicit+DEFAULT+value+is+deprecated.+Please+use+--explicit_defaults_for_timestamp+server+option+(see+documentation+for+more+details).
2019-01-23T15:11:22.435428Z+0+[ERROR]+--initialize+specified+but+the+data+directory+has+files+in+it.+Aborting.
2019-01-23T15:11:22.435653Z+0+[ERROR]+Aborting|code-block|syntax|javascript|356631|解决方案(这将删除所有数据库和表，进行备份！)：|356632|/etc/init.d/mysql+stop
rm+/var/lib/mysql+-rf
mkdir+/var/lib/mysql
chown+mysql:mysql+/var/lib/mysql
mysqld+--initialize|356633|现在在您的/etc/mysql/mysql.conf.d/mysqld.cnf中添加skip-grant-tables，因为根密码无效，所以我们需要以某种方式登录并设置一个新密码。|offset|length|style|CODE|356634|/etc/init.d/mysql+start
mysql
mysql>+show+databases;
%2B--------------------%2B
%7C+Database+++++++++++%7C
%2B--------------------%2B
%7C+information_schema+%7C
%7C+mysql++++++++++++++%7C
%7C+performance_schema+%7C
%7C+sys++++++++++++++++%7C
%2B--------------------%2B
4+rows+in+set+(0.00+sec)

mysql>+use+mysql;

Database+changed
mysql>+show+tables;
%2B---------------------------%2B
%7C+Tables_in_mysql+++++++++++%7C
%2B---------------------------%2B
%7C+columns_priv++++++++++++++%7C
%7C+db++++++++++++++++++++++++%7C
%7C+engine_cost+++++++++++++++%7C
%7C+event+++++++++++++++++++++%7C
%7C+func++++++++++++++++++++++%7C
%7C+general_log+++++++++++++++%7C
%7C+gtid_executed+++++++++++++%7C
%7C+help_category+++++++++++++%7C
%7C+help_keyword++++++++++++++%7C
%7C+help_relation+++++++++++++%7C
%7C+help_topic++++++++++++++++%7C
%7C+innodb_index_stats++++++++%7C
%7C+innodb_table_stats++++++++%7C
%7C+ndb_binlog_index++++++++++%7C
%7C+plugin++++++++++++++++++++%7C
%7C+proc++++++++++++++++++++++%7C
%7C+procs_priv++++++++++++++++%7C
%7C+proxies_priv++++++++++++++%7C
%7C+server_cost+++++++++++++++%7C
%7C+servers+++++++++++++++++++%7C
%7C+slave_master_info+++++++++%7C
%7C+slave_relay_log_info++++++%7C
%7C+slave_worker_info+++++++++%7C
%7C+slow_log++++++++++++++++++%7C
%7C+tables_priv+++++++++++++++%7C
%7C+time_zone+++++++++++++++++%7C
%7C+time_zone_leap_second+++++%7C
%7C+time_zone_name++++++++++++%7C
%7C+time_zone_transition++++++%7C
%7C+time_zone_transition_type+%7C
%7C+user++++++++++++++++++++++%7C
%2B---------------------------%2B
31+rows+in+set+(0.00+sec)|356635|所以现在你有了一个新的mysql数据库和用户表，但是密码是“乱七八糟的”。所以你需要设置一个有效的密码：|356636|SET+PASSWORD+FOR+'root'@'localhost'+=+PASSWORD('somepass');
FLUSH+PRIVILEGES;
ctrl%2Bd|356637|现在从您的配置中删除skip-grant-tables，否则您的设置是不安全的。|356638|现在你可以“正常”登录了：mysql+-u+root+-p+(输入somepass)|356639|entityMap^0|0|0|0|0|5|Y|16|H|0|0|0|0|A|H|0|D|G|X|8|0^^$0|@$1|2|3|4|5|6|7|12|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|13|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|14|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|15|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|16|8|@$M|17|N|18|O|P]|$M|19|N|1A|O|P]]|9|@]|A|$]]|$1|Q|3|R|5|D|7|1B|8|@]|9|@]|A|$E|F]]|$1|S|3|T|5|6|7|1C|8|@]|9|@]|A|$]]|$1|U|3|V|5|D|7|1D|8|@]|9|@]|A|$E|F]]|$1|W|3|X|5|6|7|1E|8|@$M|1F|N|1G|O|P]]|9|@]|A|$]]|$1|Y|3|Z|5|6|7|1H|8|@$M|1I|N|1J|O|P]|$M|1K|N|1L|O|P]]|9|@]|A|$]]|$1|10|3|-4|5|6|7|1M|8|@]|9|@]|A|$]]]|11|$]]

I had this error:

<pre><code>root@ubuntu-2gb-nbg1-1 ~ # mysqld --initialize
2019-01-23T15:11:22.428139Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2019-01-23T15:11:22.435428Z 0 [ERROR] --initialize specified but the data directory has files in it. Aborting.
2019-01-23T15:11:22.435653Z 0 [ERROR] Aborting

</code></pre>

Solution (this will delete all your databases and tables, make a backup!):

<pre><code>/etc/init.d/mysql stop
rm /var/lib/mysql -rf
mkdir /var/lib/mysql
chown mysql:mysql /var/lib/mysql
mysqld --initialize
</code></pre>

Now add <code>skip-grant-tables</code> in your <code>/etc/mysql/mysql.conf.d/mysqld.cnf</code>, because the root password is not valid, so we need to login somehow and set a new one.

<pre><code>/etc/init.d/mysql start
mysql
mysql&gt; show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sys |
+--------------------+
4 rows in set (0.00 sec)

mysql&gt; use mysql;

Database changed
mysql&gt; show tables;
+---------------------------+
| Tables_in_mysql |
+---------------------------+
| columns_priv |
| db |
| engine_cost |
| event |
| func |
| general_log |
| gtid_executed |
| help_category |
| help_keyword |
| help_relation |
| help_topic |
| innodb_index_stats |
| innodb_table_stats |
| ndb_binlog_index |
| plugin |
| proc |
| procs_priv |
| proxies_priv |
| server_cost |
| servers |
| slave_master_info |
| slave_relay_log_info |
| slave_worker_info |
| slow_log |
| tables_priv |
| time_zone |
| time_zone_leap_second |
| time_zone_name |
| time_zone_transition |
| time_zone_transition_type |
| user |
+---------------------------+
31 rows in set (0.00 sec)

</code></pre>

So now you have a new mysql database with user table, but the password is "messed up". So you need to set a valid password:

<pre><code>SET PASSWORD FOR 'root'@'localhost' = PASSWORD('somepass');
FLUSH PRIVILEGES;
ctrl+d
</code></pre>

Now remove the <code>skip-grant-tables</code> from your config, otherwise your setup is insecure.

Now you can login "normally": <code>mysql -u root -p</code> (enter <code>somepass</code>)

blocks|key|4290048|text|我遇到了一个类似的问题:在备份和恢复操作期间，我们删除了mysql和information_schema数据库。在恢复我们自己的数据库之后，我们无法创建用户(或实际执行任何操作)，因为这些系统表没有恢复。(当然，我们也不会在公司的生产环境中这样做)。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4290049|如果您仍然拥有旧mysql_install_db的副本(就像我们一样)，请不要使用它。由于是MySQL+5.6.8，所以它是一个perl脚本。采用与mysqld_safe类似的选项。对我们来说工作得很好-在恢复的数据库上运行InnoDB恢复，安装系统数据库，让我们的从属服务器恢复运行。|offset|length|4290050|entityMap|0|LINK|mutability|MUTABLE|url|http://dev.mysql.com/doc/refman/5.6/en/mysql-install-db.html^0|0|1A|B|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@]|9|@$D|P|E|Q|1|R]]|A|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|A|$]]]|G|$H|$5|I|J|K|A|$L|M]]]]

I had a similar problem : during a backup-and-restore operation we deleted the mysql and information_schema databases. After restoring our own database, we couldn't create users (or do anything really) because those system tables were not restored. (of course we would never do that in a production environment in a company either heh).

If you still have a copy of the old mysql_install_db (as we did), don't use it. Since <a href="http://dev.mysql.com/doc/refman/5.6/en/mysql-install-db.html" rel="nofollow">MySQL 5.6.8</a> it's a perl script. Takes similar options to mysqld_safe. worked well for us - ran the InnoDB recovery on our restored db, installed the system databases, got our slave server back into action.

blocks|key|356655|text|在macOS上|type|unstyled|depth|inlineStyleRanges|entityRanges|data|356656|操作系统：+macOS蒙特利|offset|length|style|BOLD|356657|苹果芯片：+M1|356658|解决方案|356659|356660|您的文件路径可以不同，请查看它！|blockquote|356661|356662|356663|停止mysql服务：brew+services+stop+mysql，|CODE|356664|ordered-list-item|356665|356666|删除Mysql数据目录：rm+-r+/opt/homebrew/var/mysql，|356667|356668|356669|Mysql+|356670|创建一个新的数据目录：mkdir+/opt/homebrew/var/mysql|unordered-list-item|356671|356672|初始化Mysql数据目录：mysqld+--initialize，|356673|356674|356675|356676|将skip-grant-tables添加到文件/opt/homebrew/etc/my.cnf，以便无需密码即可连接到Mysql服务器。|356677|356678|356679|启动Mysql服务：brew+services+start+mysql|356680|356681|运行Mysql客户端：mysql的|356682|356683|356684|Mysql客户端上的|356685|运行以下命令：|356686|356687|use+mysql;+#+switch+to+mysql+database|356688|FLUSH+PRIVILEGES;|356689|SET+PASSWORD+FOR+'root'@'localhost'+=+PASSWORD('<new-password>');|356690|FLUSH+PRIVILEGES;|356691|从文件/opt/homebrew/etc/my.cnf中删除|356692|+skip-grant-tables|356693|356694|然后重新启动服务：brew+services+restart+mysql+|356695|356696|356697|使用新密码mysql+-u+root+-p登录|356698|客户端|356699|356700|命令摘要|356701|brew+services+stop+mysql
rm+-r+/opt/homebrew/var/mysql
mkdir+/opt/homebrew/var/mysql
mysqld+--initialize

#+Add+skip-grant-tables+to+/opt/homebrew/etc/my.cnf
brew+services+start+mysql
mysql

#+Run+on+mysql:+use+mysql;+#+switch+to+mysql+database
#+Run+on+mysql:+FLUSH+PRIVILEGES;
#+Run+on+mysql:+SET+PASSWORD+FOR+'root'@'localhost'+=+PASSWORD('<new-password>');
#+Run+on+mysql:+FLUSH+PRIVILEGES;
#+Run+on+mysql:+exit;
#+Remove+`skip-grant-tables`+from+`/opt/homebrew/etc/my.cnf`

brew+services+restart+mysql
mysql+-u+root+-p|code-block|syntax|javascript|356702|entityMap^0|0|0|5|0|5|3|0|0|4|0|0|0|G|0|0|0|0|Z|A|O|0|0|0|0|16|C|T|0|0|0|0|6|0|0|14|B|T|0|0|0|X|D|J|0|0|0|0|0|1W|1|H|N|O|0|0|0|0|Z|A|P|0|0|0|H|B|5|0|0|0|0|A|0|0|7|0|0|0|11|0|11|0|0|H|0|H|0|0|1T|0|1T|0|0|H|0|H|0|0|U|3|O|0|1|H|1|H|0|0|0|10|9|R|0|0|0|0|N|5|G|0|0|3|0|0|0|4|0|0^^$0|@$1|2|3|4|5|6|7|2N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|2O|8|@$D|2P|E|2Q|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|2R|8|@$D|2S|E|2T|F|G]]|9|@]|A|$]]|$1|J|3|K|5|6|7|2U|8|@$D|2V|E|2W|F|G]]|9|@]|A|$]]|$1|L|3|-4|5|6|7|2X|8|@]|9|@]|A|$]]|$1|M|3|N|5|O|7|2Y|8|@$D|2Z|E|30|F|G]]|9|@]|A|$]]|$1|P|3|-4|5|6|7|31|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|32|8|@]|9|@]|A|$]]|$1|R|3|S|5|6|7|33|8|@$D|34|E|35|F|G]|$D|36|E|37|F|T]]|9|@]|A|$]]|$1|U|3|-4|5|V|7|38|8|@]|9|@]|A|$]]|$1|W|3|-4|5|6|7|39|8|@]|9|@]|A|$]]|$1|X|3|Y|5|6|7|3A|8|@$D|3B|E|3C|F|G]|$D|3D|E|3E|F|T]]|9|@]|A|$]]|$1|Z|3|-4|5|V|7|3F|8|@]|9|@]|A|$]]|$1|10|3|-4|5|6|7|3G|8|@]|9|@]|A|$]]|$1|11|3|12|5|6|7|3H|8|@$D|3I|E|3J|F|G]]|9|@]|A|$]]|$1|13|3|14|5|15|7|3K|8|@$D|3L|E|3M|F|G]|$D|3N|E|3O|F|T]]|9|@]|A|$]]|$1|16|3|-4|5|6|7|3P|8|@]|9|@]|A|$]]|$1|17|3|18|5|6|7|3Q|8|@$D|3R|E|3S|F|G]|$D|3T|E|3U|F|T]]|9|@]|A|$]]|$1|19|3|-4|5|V|7|3V|8|@]|9|@]|A|$]]|$1|1A|3|-4|5|6|7|3W|8|@]|9|@]|A|$]]|$1|1B|3|-4|5|6|7|3X|8|@]|9|@]|A|$]]|$1|1C|3|1D|5|V|7|3Y|8|@$D|3Z|E|40|F|G]|$D|41|E|42|F|T]|$D|43|E|44|F|T]]|9|@]|A|$]]|$1|1E|3|-4|5|6|7|45|8|@]|9|@]|A|$]]|$1|1F|3|-4|5|6|7|46|8|@]|9|@]|A|$]]|$1|1G|3|1H|5|V|7|47|8|@$D|48|E|49|F|G]|$D|4A|E|4B|F|T]]|9|@]|A|$]]|$1|1I|3|-4|5|6|7|4C|8|@]|9|@]|A|$]]|$1|1J|3|1K|5|6|7|4D|8|@$D|4E|E|4F|F|G]|$D|4G|E|4H|F|T]]|9|@]|A|$]]|$1|1L|3|-4|5|V|7|4I|8|@]|9|@]|A|$]]|$1|1M|3|-4|5|6|7|4J|8|@]|9|@]|A|$]]|$1|1N|3|1O|5|6|7|4K|8|@$D|4L|E|4M|F|G]]|9|@]|A|$]]|$1|1P|3|1Q|5|V|7|4N|8|@$D|4O|E|4P|F|G]]|9|@]|A|$]]|$1|1R|3|-4|5|6|7|4Q|8|@]|9|@]|A|$]]|$1|1S|3|1T|5|6|7|4R|8|@$D|4S|E|4T|F|G]|$D|4U|E|4V|F|T]]|9|@]|A|$]]|$1|1U|3|1V|5|6|7|4W|8|@$D|4X|E|4Y|F|G]|$D|4Z|E|50|F|T]]|9|@]|A|$]]|$1|1W|3|1X|5|6|7|51|8|@$D|52|E|53|F|G]|$D|54|E|55|F|T]]|9|@]|A|$]]|$1|1Y|3|1Z|5|6|7|56|8|@$D|57|E|58|F|G]|$D|59|E|5A|F|T]]|9|@]|A|$]]|$1|20|3|21|5|6|7|5B|8|@$D|5C|E|5D|F|G]|$D|5E|E|5F|F|T]]|9|@]|A|$]]|$1|22|3|23|5|V|7|5G|8|@$D|5H|E|5I|F|G]|$D|5J|E|5K|F|T]]|9|@]|A|$]]|$1|24|3|-4|5|6|7|5L|8|@]|9|@]|A|$]]|$1|25|3|26|5|6|7|5M|8|@$D|5N|E|5O|F|G]|$D|5P|E|5Q|F|T]]|9|@]|A|$]]|$1|27|3|-4|5|V|7|5R|8|@]|9|@]|A|$]]|$1|28|3|-4|5|6|7|5S|8|@]|9|@]|A|$]]|$1|29|3|2A|5|6|7|5T|8|@$D|5U|E|5V|F|G]|$D|5W|E|5X|F|T]]|9|@]|A|$]]|$1|2B|3|2C|5|V|7|5Y|8|@$D|5Z|E|60|F|G]]|9|@]|A|$]]|$1|2D|3|-4|5|6|7|61|8|@]|9|@]|A|$]]|$1|2E|3|2F|5|6|7|62|8|@$D|63|E|64|F|G]]|9|@]|A|$]]|$1|2G|3|2H|5|2I|7|65|8|@]|9|@]|A|$2J|2K]]|$1|2L|3|-4|5|6|7|66|8|@]|9|@]|A|$]]]|2M|$]]

<h1>On macOS</h1>
OS: macOS Monterey
Chip: Apple M1
<h2>Solution</h2>
<blockquote>
Your file paths can be different, please review it!
</blockquote>
<ol>
<li>Stop mysql service: <code>brew services stop mysql</code>
</li>
<li>Remove Mysql data directory: <code>rm -r /opt/homebrew/var/mysql</code>
</li>
<li>Create a new Mysql data directory: <code>mkdir /opt/homebrew/var/mysql</code>
</li>
<li>Initialize Mysql data directory: <code>mysqld --initialize</code>
</li>
<li>Add <code>skip-grant-tables</code> to the file <code>/opt/homebrew/etc/my.cnf</code> to allow connect to Mysql server without password.
</li>
<li>Start Mysql service: <code>brew services start mysql</code>
</li>
<li>Run Mysql client: <code>mysql</code>
</li>
<li>On Mysql client run the following commands:
<code>use mysql; # switch to mysql database</code>
<code>FLUSH PRIVILEGES;</code>
<code>SET PASSWORD FOR 'root'@'localhost' = PASSWORD('&lt;new-password&gt;');</code>
<code>FLUSH PRIVILEGES;</code>
</li>
<li>Remove <code>skip-grant-tables</code> from the file <code>/opt/homebrew/etc/my.cnf</code>
</li>
<li>Then restart the service: <code>brew services restart mysql</code>
</li>
<li>Login into Mysql client with your new password: <code>mysql -u root -p</code>
</li>
</ol>
<h2>Command Summary</h2>
<pre><code>brew services stop mysql
rm -r /opt/homebrew/var/mysql
mkdir /opt/homebrew/var/mysql
mysqld --initialize

# Add skip-grant-tables to /opt/homebrew/etc/my.cnf
brew services start mysql
mysql

# Run on mysql: use mysql; # switch to mysql database
# Run on mysql: FLUSH PRIVILEGES;
# Run on mysql: SET PASSWORD FOR 'root'@'localhost' = PASSWORD('&lt;new-password&gt;');
# Run on mysql: FLUSH PRIVILEGES;
# Run on mysql: exit;
# Remove `skip-grant-tables` from `/opt/homebrew/etc/my.cnf`

brew services restart mysql
mysql -u root -p
</code></pre>

When I installed mysql it came with two database, mysql and information schema. I accidentally deleted the mysql database. Is there any way I can recreate it?

Also, since it contains a table that contains user information, would there be any way I can view users' information without it?

How to recover/recreate mysql's default 'mysql' database

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

EdgeOne AI 安全实战专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

当我安装mysql时，它附带了两个数据库，mysql和信息模式。我不小心删除了mysql数据库。有没有办法让我重现它？此外，由于它包含一个包含用户信息的表，因此有没有办法在没有它的情况下查看用户信息？

问如何恢复/重新创建mysql的默认'mysql‘数据库
EN

回答 7

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何恢复/重新创建mysql的默认'mysql‘数据库EN

回答 7

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何恢复/重新创建mysql的默认'mysql‘数据库
EN