Operation and Maintenance
Linux Operation and Maintenance
What to do if linux mysqld cannot start
What to do if linux mysqld cannot start
Solution to the problem that linux mysqld cannot start: 1. Install mysql through the "yum install mysql-server" command; 2. Open "my.cnf", and then add a line "skip-" under "[mysqld]" grant-tables"; 3. Restart mysql through "systemctl restart mysqld".
The operating environment of this tutorial: linux5.9.8 system, mysql version 5.7, DELL G3 computer
What to do if linux mysqld cannot start ?
Common solutions to mysql installation failure and startup failure in Linux
##1. Mysql failed to start after installation
- Use the command
systemctl start mysqld.service
- An error occurred ：Unit mysql.service could not be found
- Issues a question whether mysql is installed successfully, use the command to find
find / -name mysql
- It is found that the /usr/bin/mysql directory does not exist, indicating that the installation failed.
Then use yum to install mysql
1.1 Solve the problem that the public key has not been installed when installing Centos7 yum
Installation commandyum install mysql-server
2. First time login without password
2.1 Enter mysqld.logcat /var/log/mysqld.log | grep 'root@localhost:'
2022-05-13T02:35:13.846556Z 1 [Note] A temporary password is generated for root@localhost: a#sE2lVHzzvV
If the connection is still refused, try skipping the password to enter: enter vim /etc/my.cnf and add a line under [mysqld]skip-grant -tables is used to skip the password verification process, and then restart mysql systemctl restart mysqld, and then enter the command mysql to enter. After changing the password, you can remove this line Configure and then reboot.
flush privileges; alter user root@localhost identified by '1234';
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
alter user root@localhost identified by 'Han123..' # mysql5.7 ，若失败可以将root@localhost替换root@%试试 ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'Han123..'; # mysql8.0，若失败可以将'root'@'localhost'替换'root'@'%'试试
The above is the detailed content of What to do if linux mysqld cannot start. For more information, please follow other related articles on the PHP Chinese website!
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
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
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
1667
14
1426
52
1328
25
1273
29
1255
24
Linux Architecture: Unveiling the 5 Basic Components
Apr 20, 2025 am 12:04 AM
The five basic components of the Linux system are: 1. Kernel, 2. System library, 3. System utilities, 4. Graphical user interface, 5. Applications. The kernel manages hardware resources, the system library provides precompiled functions, system utilities are used for system management, the GUI provides visual interaction, and applications use these components to implement functions.
vscode Previous Next Shortcut Key
Apr 15, 2025 pm 10:51 PM
VS Code One-step/Next step shortcut key usage: One-step (backward): Windows/Linux: Ctrl ←; macOS: Cmd ←Next step (forward): Windows/Linux: Ctrl →; macOS: Cmd →
How to check the warehouse address of git
Apr 17, 2025 pm 01:54 PM
To view the Git repository address, perform the following steps: 1. Open the command line and navigate to the repository directory; 2. Run the "git remote -v" command; 3. View the repository name in the output and its corresponding address.
How to run java code in notepad
Apr 16, 2025 pm 07:39 PM
Although Notepad cannot run Java code directly, it can be achieved by using other tools: using the command line compiler (javac) to generate a bytecode file (filename.class). Use the Java interpreter (java) to interpret bytecode, execute the code, and output the result.
How to run sublime after writing the code
Apr 16, 2025 am 08:51 AM
There are six ways to run code in Sublime: through hotkeys, menus, build systems, command lines, set default build systems, and custom build commands, and run individual files/projects by right-clicking on projects/files. The build system availability depends on the installation of Sublime Text.
What is the main purpose of Linux?
Apr 16, 2025 am 12:19 AM
The main uses of Linux include: 1. Server operating system, 2. Embedded system, 3. Desktop operating system, 4. Development and testing environment. Linux excels in these areas, providing stability, security and efficient development tools.
laravel installation code
Apr 18, 2025 pm 12:30 PM
To install Laravel, follow these steps in sequence: Install Composer (for macOS/Linux and Windows) Install Laravel Installer Create a new project Start Service Access Application (URL: http://127.0.0.1:8000) Set up the database connection (if required)
git software installation
Apr 17, 2025 am 11:57 AM
Installing Git software includes the following steps: Download the installation package and run the installation package to verify the installation configuration Git installation Git Bash (Windows only)
