Mysql installation-free does not have any root permission, mysql installation-free root

Mysql installation-free does not have any root permission, mysql installation-free root

1. Download MySQL Community Server 5.5.41 Linux-Generic Compressed TAR Archive mysql download link

2. decompress the tar package. For example, decompress the package to the/home/work directory. For example, because the file name is too long, you can rename the package or create a soft link. Renamed mysql.

3. # cd mysql-go to the mysql working directory

4, # cp support-files/my-medium.cnf my. cnf-copy the official configuration file

# Vi my. cnf-Modify and add some configuration items

 user   = work port   = 3306 socket   = /home/work/mysql/mysql.sock # Here follows entries for some specific programs # The MySQL server [mysqld] user   = work port   = 3306 socket   = /home/work/mysql/mysql.sock  pid-file  = /home/work/mysql/mysql.pid basedir   = /home/work/mysql datadir   =/home/work/mysql/data log-error  =/home/work/mysql/logs/mysql_error.log

5. Execute the installation script

# Scripts/mysql_install_db-user = work console outputs the following content, indicating that the installation is successful

6. # bin/mysqld_safe-defaults-file = my. cnf &-start the service. Note: You need to add the configuration file path parameters.

7. #./bin/mysqladmin-defaults-file = my. cnf-u root password 'new-password'-set the user logon password

8. #./bin/mysql-defaults-file = my. cnf-u root-p-re-open a console and log on to mysql

The link to the installation instructions of the last official document is as follows:

The above is a small Editor to introduce you to mysql without installation without any root permissions, I hope to help you, if you have any questions, please leave a message, the small editor will reply to you in a timely manner. Thank you very much for your support for the help House website!