


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











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.

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 →

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.

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.

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.

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.

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)

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)
