我要投稿 如果你有好的文章,欢迎分享给我们,我们会给与适当的补贴

MariaDB的简单配置

首先呢,我想要承认说,我是一个小白,这里的记录是我自己的一个笔记。大神就直接跳过吧。

mysql_secure_installation 
Set root password? [Y/n] y 
New password: Re-enter new password: Password updated successfully! Reloading privilege tables.. … Success! By default, a MariaDB installation has an anonymous user, allowing anyone to log into MariaDB without having to have a user account created for them. This is intended only for testing, and to make the installation go a bit smoother. You should remove them before moving into a production environment. 
Remove anonymous users? [Y/n] y … Success! Normally, root should only be allowed to connect from 'localhost'. This ensures that someone cannot guess at the root password from the network. 
Disallow root login remotely? [Y/n] y … Success! By default, MariaDB comes with a database named 'test' that anyone can access. This is also intended only for testing, and should be removed before moving into a production environment. Remove test database and access to it? [Y/n] y 
Dropping test database… … Success! Removing privileges on test database… … Success! Reloading the privilege tables will ensure that all changes made so far will take effect immediately. 
Reload privilege tables now? [Y/n] y … Success! Cleaning up… All done! If you've completed all of the above steps, your MariaDB installation should now be secure. Thanks for using MariaDB! 

mysql -uroot -p #进入mysql终端
CREATE USER 'leitalk'@'localhost' IDENTIFIED BY '[email protected]#';
CREATE DATABASE `leitalk` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci */;
GRANT all ON leitalk.* TO 'leitalk'@'localhost';
FLUSH PRIVILEGES;
exit #退出

首先呢

Tags:

Add a Comment

Your email address will not be published. Required fields are marked *