Home PC Games Linux Windows Database Network Programming Server Mobile  
  Home \ Database \ Ubuntu mysql stop fail to solve the problem     - Copy U disk files to the Linux system on a virtual machine (Linux)

- Package the Python script file into an executable file (Programming)

- To setup a ftp server under Linux (Server)

- Android components save state series - Activity (Programming)

- PostgreSQL using the system cache to improve operational efficiency (Database)

- secureCRT remote login Linux must first open the connection protocol (Linux)

- The Objects in JavaScript (Programming)

- PostgreSQL export table structure information (Database)

- Ubuntu install Wireshark (Linux)

- LVM basic concepts, management (Linux)

- EChart simple and practical control on chart (Programming)

- How do I delete a NEEDS RECOVERY rollback state of undo tablespace (Database)

- How to manage KVM virtual environments with command-line tools in Linux (Server)

- Why do I prefer Git (Linux)

- Monitor traffic Linux Shell Edition (Programming)

- Build ftp server under CentOS 6.5 (Server)

- MySQL appears data too long for column 'name' at row 1 to solve (Database)

- Use smartmontools view the health status of hard disk (Linux)

- Use preseed script to install Ubuntu 14.04 (Linux)

- Linux command execution judge sentences -;, &&, || (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.
- Oracle Bug caused by the collection of AWR Snapshot fault (Database)
- Using C ++ Container Templates in Shared Memory (Programming)
- Raspberry Pi 2 to install the latest version of the FPC and Lazarus 1.5 (Linux)
- Android using SVG vector graphics to create cool animation effects (Programming)
- Linux System Getting Started Learning: Linux command in w (Linux)
- Linux instructions and examples GPG encryption and decryption (Linux)
- Normal start Lazarus 1.0.8 under Ubuntu (Linux)
- CentOS of NFS (Server)
- Binary Tree Traversal (Linux)
- Sublime Text - Opens the current file in a browser (Linux)
- Ubuntu Linux use ufw or iptables firewall configuration (Linux)
- Use MD5 transform algorithm to prevent exhaustive decipher passwords (Linux)
- Type Linux commands (Linux)
- Linux account related documents Interpretation (Linux)
- libreadline.so.6: can not open shared object file problem solution (Linux)
- To compile and install Clang 3.5.0 in Linux CentOS (Linux)
- Linux system last command usage (Linux)
- RHEL6.4 x86_64 build SVN service (Server)
- How do you access Dropbox Linux command line (Linux)
- Oracle table space create large files (Database)
  CopyRight 2002-2022 newfreesoft.com, All Rights Reserved.