Operation and Maintenance
Linux Operation and Maintenance
What permissions are used to start linux mysql?
What permissions are used to start linux mysql?
linux mysql is started with root permissions. The method to enable mysql access permissions in Linux is: 1. Check whether the listening port exists through the "netstat -ntlp | grep mysql" command; 2. Check the Mysql configuration; 3. Enter Just execute the command "mysql -u root -p use mysql;" on the database.
The operating environment of this tutorial: linux5.9.8 system, MySQL5.7, Dell G3 computer.
What permissions are used to start linux mysql?
Enable remote access permissions for Mysql in Linux environment
Remotely connect to Mysql installed on Linux through Window's database visualization tool
You can follow the following steps to confirm one by one!
Check whether the listening port exists
netstat -ntlp |grep mysql
Check the Mysql configuration
Execute first: vim /etc/my.cnf
[mysqld] port = 3306 bind-address = 0.0.0.0 # 这一行改成0.0.0.0 或者直接注释掉 socket = /tmp/mysql.sock datadir = /usr/local/mysql/var skip-external-locking
Enter the database and execute the following commands in sequence
mysql -u root -p use mysql;
- ##GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456'; #The 123456 here is the password you set for the new privileged user, % represents all hosts, or it can be specific to your host IP address
- flush privileges; #Re Load permission data
- select * from user; #Query whether the setting is successful
Linux Video Tutorial 》
The above is the detailed content of What permissions are used to start linux mysql?. 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)
