Install MySQL under Ubuntu10.10

Install MySQL in Ubuntu10.10. terminal installation (1) the terminal executes the command: sudo apt-get install mysql-server mysql-client (2) Check the installation result sudo netstat-tap | grep mysql when you run this command, you can see a line similar to the following: tcp 0 0 localhost. localdo: mysql *: * LISTEN (3) manually start MySQL sudo start mysql sudo stop mysql (4) configure the MySQL administrator password sudo mysqladmin-u root password newpassword (5) check the MySQL process pgrep mysql. The result will be returned to the process ID.2. install the system in the New Software Installation Tool-> System Management-> New Software Package Manager, search for mysql-server and mysql-cli Install the client separately. 3. file structure MySQL configuration file:/etc/mysql/my. cnf, which specifies the data file storage path datadir =/var/lib/mysql. If you create a database named test, the data in this database will be stored in the/var/lib/mysql/test directory. 4. Enter the MySQL-u root prompt and enter the root password. 5. display Scheme show databases; by SpringsFeng