MySQL安全配置向导mysql_secure_installation详解_MySQL
bitsCN.com
安装完mysql-server 会提示可以运行mysql_secure_installation。运行mysql_secure_installation会执行几个设置：
a)为root用户设置密码
b)删除匿名账号
c)取消root用户远程登录
d)删除test库和对test库的访问权限
e)刷新授权表使修改生效
通过这几项的设置能够提高mysql库的安全。建议生产环境中mysql安装这完成后一定要运行一次mysql_secure_installation，详细步骤请参看下面的命令:
[root@server1 ~]# mysql_secure_installation
NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL
SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY!
In order to log into MySQL to secure it, we'll need the current
password for the root user. If you've just installed MySQL, and
you haven't set the root password yet, the password will be blank,
so you should just press enter here.
Enter current password for root (enter for none):
OK, successfully used password, moving on…
Setting the root password ensures that nobody can log into the MySQL
root user without the proper authorisation.
Set root password? [Y/n]
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
1386
52
How to use Xiaohongshu account to find users? Can I find my mobile phone number?
Mar 22, 2024 am 08:40 AM
With the rapid development of social media, Xiaohongshu has become one of the most popular social platforms. Users can create a Xiaohongshu account to show their personal identity and communicate and interact with other users. If you need to find a user’s Xiaohongshu number, you can follow these simple steps. 1. How to use Xiaohongshu account to find users? 1. Open the Xiaohongshu APP, click the "Discover" button in the lower right corner, and then select the "Notes" option. 2. In the note list, find the note posted by the user you want to find. Click to enter the note details page. 3. On the note details page, click the "Follow" button below the user's avatar to enter the user's personal homepage. 4. In the upper right corner of the user's personal homepage, click the three-dot button and select "Personal Information"
How to solve the problem that Windows 11 prompts you to enter the administrator username and password to continue?
Apr 11, 2024 am 09:10 AM
When using Win11 system, sometimes you will encounter a prompt that requires you to enter the administrator username and password. This article will discuss how to deal with this situation. Method 1: 1. Click [Windows Logo], then press [Shift+Restart] to enter safe mode; or enter safe mode this way: click the Start menu and select Settings. Select "Update and Security"; select "Restart Now" in "Recovery"; after restarting and entering the options, select - Troubleshoot - Advanced Options - Startup Settings -&mdash
What should I do if I can't log in to my Google Chrome account? Google account shows unable to log in solution
Mar 17, 2024 am 08:30 AM
Google Chrome is a web browsing tool used by many people. In order to make it more convenient to use, some users want to log in to their Google account first, but a prompt that the account cannot be logged in appears. Regarding this issue, many users do not know what to do. How to solve it, then today the editor will share the complete solution with you. I hope that the content of today’s software tutorial can help the majority of users. Google account shows that you cannot log in. Solution: 1. Click on a browser on the desktop and you will see something like this after opening it. 2. If a login pops up at this time, click it. If you can't see it, click the upper right corner. 3. Click Login, then enter your account number. You do not need to enter the account after @, and click Next. 4. Enter the password,
How to have multiple accounts on Xiaohongshu? How does it have traffic?
Mar 24, 2024 pm 03:36 PM
As a content-rich social e-commerce platform, Xiaohongshu has attracted a large number of users. For those who want to conduct multiple businesses on Xiaohongshu, it is particularly important to have multiple accounts. So, how does Xiaohongshu have multiple accounts? How can we make these accounts have traffic? This article will analyze these issues in detail and provide you with helpful guidance. 1. How to have multiple accounts on Xiaohongshu? When registering a Xiaohongshu account, you can choose to register multiple accounts using different mobile phone numbers or email addresses in order to have multiple accounts. Real-name authentication is an effective measure to improve account security and credibility. It is recommended to conduct real-name authentication for each account, so that the account will be more authoritative and credible. 3. Improve the information: Improve the information of each account, including personal homepage, header
How to change the mobile phone number of Xiaohongshu account? Will there be any impact if I change my mobile phone number?
Mar 22, 2024 am 08:11 AM
In the digital age, Xiaohongshu has become a platform for many people to share their lives and discover good things. Over time, we may need to change the mobile phone number on the account. So, how to change Xiaohongshu’s mobile phone number? 1. How to change the mobile phone number of Xiaohongshu account? 1. Log in to your Xiaohongshu account and enter the “My” page. 2. Click "..." in the upper right corner and select "Settings". 3. On the settings page, find the "Account and Security" option and click to enter. 4. On the Account and Security page, find the "Mobile Phone Number" option and click to enter. 5. At this time, the page will display the current mobile phone number, click "Change Mobile Number". 6. Enter the new mobile phone number, receive the verification code, and fill it out. 7. Set a new password to ensure account security. 8. After completing the above steps,
Log in to Ubuntu as superuser
Mar 20, 2024 am 10:55 AM
In Ubuntu systems, the root user is usually disabled. To activate the root user, you can use the passwd command to set a password and then use the su- command to log in as root. The root user is a user with unrestricted system administrative rights. He has permissions to access and modify files, user management, software installation and removal, and system configuration changes. There are obvious differences between the root user and ordinary users. The root user has the highest authority and broader control rights in the system. The root user can execute important system commands and edit system files, which ordinary users cannot do. In this guide, I'll explore the Ubuntu root user, how to log in as root, and how it differs from a normal user. Notice
How do I have two Xiaohongshu accounts? What use does having two Xiaohongshu accounts do to creators?
Mar 21, 2024 pm 10:11 PM
As a platform that integrates community, content and e-commerce, Xiaohongshu has attracted the attention of many creators and users. Some users want to have two Xiaohongshu accounts to better manage and operate different types of content. This article will explore how to create two Xiaohongshu accounts and explore the potential benefits of this approach for creators. 1. How to have two Xiaohongshu accounts? Registering a new account is very simple. Just download the Xiaohongshu APP from the mobile app store, then fill in the relevant information according to the prompts and set the nickname, avatar and password. 2. Log in to the original account: After registering a new account, you need to log out of the Xiaohongshu APP and then log in to your original account again. 3. Switch accounts: In the Xiaohongshu APP, click "My" in the lower right corner, then click the avatar and select "
How to set router WiFi password using mobile phone (using mobile phone as tool)
Apr 24, 2024 pm 06:04 PM
Wireless networks have become an indispensable part of people's lives in today's digital world. Protecting the security of personal wireless networks is particularly important, however. Setting a strong password is key to ensuring that your WiFi network cannot be hacked by others. To ensure your network security, this article will introduce in detail how to use your mobile phone to change the router WiFi password. 1. Open the router management page - Open the router management page in the mobile browser and enter the router's default IP address. 2. Enter the administrator username and password - To gain access, enter the correct administrator username and password in the login page. 3. Navigate to the wireless settings page - find and click to enter the wireless settings page, in the router management page. 4. Find the current Wi
