Home PC Games Linux Windows Database Network Programming Server Mobile  
  Home \ Database \ Ubuntu mysql stop fail to solve the problem     - Repair Maven project developed default Maven Plugin folder (Linux)

- MySQL 5.7 perfectly distributed transaction support (Database)

- Detailed Linux su command to switch users Mistakes (Linux)

- How to upgrade to Ubuntu 14.04 Linux Kernel 4.4.1 LTS (Linux)

- VSFTPD Security (Linux)

- Ubuntu install Scala 2.10.x version (Linux)

- CentOS system Amoeba + MySQL Master-slave configuration (Database)

- Based on Python: OpenCV simple image manipulation (Programming)

- Weld a problem in JDK 8u60 environment (Programming)

- How to back up Debian system backupninja (Linux)

- Ora-1092: OPI colleague K aborting process --- killed by OO Well killer (Database)

- Integrated security administrator Linux accident management (Linux)

- Based kubernetes Construction Docker Cluster Management Comments (Server)

- To install file manager Nautilus 3.12.2 under ubuntu (Linux)

- GitLab issued Merge Request return error 500 when the two solutions log (Linux)

- Setup Qt development environment under Linux (Linux)

- Inherent limitations of Linux systems network security (Linux)

- The specified user to execute commands under Linux (Linux)

- Linux process management related content (Linux)

- Debian 7.8 system installation and configuration process (Linux)

  Ubuntu mysql stop fail to solve the problem
  Add Date : 2018-11-21      
  A recent study MySQL, mysql stop fail encountered a problem where the process of solving the problems encountered and write out, the problem is not how hard, but I did not find the solution to this problem during a line of effective solution to the problem of Chinese web pages, and made a lot of wasted time. Here I write down the settlement process, newcomers hope to solve the same problem to save time. Well, ado, we began to enter the topic.

My operating system environment is Ubuntu 14.04,64 bit MySQL installation process is as follows:

Since the change of MySQL configuration file, you need to restart the MySQL, I'll stop mysql through the following two commands:

Of course, also I tried the Internet said the service mysql stop, then do not use eggs. After searching several times, finally found in an English forum solution. In the layout of the problem, there are many respondents given a "method", is given only one method to solve my problem.

The problem solving process is like this:

1, login as root mysql, execute the following sql statement:

select User from mysql.user

Look in the mysql database user table is not the presence of a file named: debian-sys-maint user, the implementation of the above sql statement returns on my machine results
If your query returns results in the absence of a centralized user debian-sys-maint, then you need to perform the second step, if there is debian-sys-maint user, then you need to perform the third step.

2, the implementation of sql statement: CREATE USER 'debian-sys-maint' @ 'localhost' identified by 'password'

I briefly explain the sql statement: create a debian-sys-maint user called, using the mysql password for the user password, then the value of the password field to specify how we do? You are arbitrarily assigned it? Not worth password fields must be the same file /etc/mysql/debian.cnf the debian-sys-maint password contents /etc/mysql/debian.cnf files on my machine
3, if you perform the second step, then you can successfully stop mysql, the need to perform the third step. The third step of the process as follows:

Value /etc/mysql/debian.cnf the debian-sys-maint first execute the following sql statement to see debian-sys-maint line where the password field corresponding to the password is the same,
Since the mysql password is stored encrypted, so we can not compare the two passwords, because we need two passwords are consistent, so execute the following sql statement:

update user set password = PASSWORD ( "password from /etc/mysql/debian.cnf") where User = 'debian-sys-maint'

Here is the password from /etc/mysql/debian.cnf /etc/mysql/debian.cnf file debian-sys-maint corresponding password, you make no mistake.

So that we can successfully stop mysql up.
- Linux Shell introduces (Linux)
- installation of Vim plugin YouCompleteMe under Ubuntu 15.04 (Linux)
- Docker Basic and Advanced (Linux)
- Piostat - Monitoring and Statistics Linux process (Linux)
- CentOS and RHEL installation under GAMIT10.6 (Linux)
- Adjustment expand VMDK format VirtualBox disk space (Linux)
- The Definitive Guide to Linux NAT network connection (Linux)
- Linux System Getting Started Learning: The Linux command line burn ISO or NRG image to DVD (Linux)
- Shell scripts to copy all directories under the current directory of a certain type of file to the same directory (Linux)
- Linux performance optimization features Tuned and ktune (Linux)
- MySQL various log summary (Database)
- Exploring the Android Listview display confusion (Programming)
- Unetbootin make use U disk loading Linux system (Linux)
- C language preprocessor command (Programming)
- Construction LVM-based raw device Oracle10g Database on Oracle Linux 5.11 (Database)
- Manage SQL Server services login (start) account and password (Database)
- Python programmers most often committed ten errors (Programming)
- Oracle user lock how to know what causes (Database)
- Linux Basics Tutorial: Combining awk delete data before the specified date hdfs (Linux)
- CentOS 6.5 installation VNCServer implement graphical access (Server)
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.