Install MySQL under Ubuntu

Preface

Ubentu is a user-friendly Linux system. First, install MySQL, which is familiar to you. You may encounter many difficulties. For example, you are not familiar with the directory structure in Linux. Click "Install". I don't know where to install MySQL. I don't know where to install it. How can I start MySQL? It's not human. It's not human. It's not logical.

Start MySQLAfter the installation is complete, starting MySQL is the primary issue. Unlike windows with EXE or services, it is OK to start it on the visualization panel. But in MySQL, where is the EXE service list? Not found. Fortunately, Google and Baidu are available. I searched the internet and found the following command: CD/etc/init. dservice MySQL start. MySQL is started remotely. How can I know that the service is in/etc/init. d? How do I know the service name is MySQL? No matter what it is, execute the command first. Otherwise, it is not as easy as I think. The error is: Starting MySQL. * The server quit without updating PID file (/var/lib/MySQL/chengziqing-vm.pid ). this is wrong .. I can't tell why .. Not human, too unhuman. Most of Google's answers are:

1. Comment out Skip-federated in/etc/My. CNF and comment out # Skip-federated;
2. The my. CNF file is too configured, and the parameters are redefined (defined based on the server situation );
3. Kill the mysql_safe and mysqld processes and restart them;
4. The current log file is too large and exceeds the size defined in my. CNF (64 MB by default). Delete the log file and restart it;
5. In other cases, view the log file (my name is localhost. localdomain. Err, which varies from person to person), and then analyze it in detail;

In conclusion, none of the above answers are correct, so I re-installed MySQL and succeeded. Nothing is wrong. If you are ill, try again.