ubuntu安装mysql

mysql有deb包，但是用过一次，感觉不如源码编译安装好，卸载后选择下载源码重新安装。

    # Preconfiguration setup

shell> 
    
      
        groupadd mysql
      
    
    

shell> 
    
      
        useradd -r -g mysql mysql
      
    
    

# Beginning of source-build specific instructions

shell> 
    
      
        tar zxvf mysql-
        
          
            VERSION
          
        
        .tar.gz
      
    
    

shell> 
    
      
        cd mysql-
        
          
            VERSION
          
        
      
    
    

shell> 
    
      
        cmake .
      
    
    

shell> 
    
      
        make
      
    
    

shell> 
    
      
        make install
      
    
    

# End of source-build specific instructions

# Postinstallation setup

shell> 
    
      
        cd /usr/local/mysql
      
    
    

shell> 
    
      
        chown -R mysql .
      
    
    

shell> 
    
      
        chgrp -R mysql .
      
    
    

shell> 
    
      
        scripts/mysql_install_db --user=mysql
      
    
    

shell> 
    
      
        chown -R root .
      
    
    

shell> 
    
      
        chown -R mysql data
      
    
    

shell> 
    
      
        bin/mysqld_safe --user=mysql &
      
    
  

ubuntu下用cmake时可能会报错，按照提示安装一个包后重新cmake。

To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system

一般是/etc/init.d／目录下。命令如下：

      
        1
      
      
        cp
      
       support-files/mysql.server /etc/init.d/
      
        mysql 


      
      
        2
      
      
        chmod
      
       +x /etc/init.d/
      
        mysql


      
      
        3
      
       chkconfig --add mysql
    

第一个命令是复制并重命名，很简单。

第二个命令为mysql服务器文件添加可执行权限。

第三个命令设置系统中所有服务在各运行级别中的启动和关闭状态。

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:

      
        1
      
       ./bin/mysqladmin -u root password 
      
        '
      
      
        new-password
      
      
        '
      
      
        2
      
       ./bin/mysqladmin -u root -h 主机 password 
      
        '
      
      
        new-password
      
      
        '
      
    

Alternatively you can run:

      
        1
      
       ./bin/mysql_secure_installation
    

which will also give you the option of removing the test
databases and anonymous user created by default. This is
strongly recommended for production servers.

See the manual for more instructions.

You can start the MySQL daemon with:

      
        1
      
       cd . ; ./bin/mysqld_safe &
    

You can test the MySQL daemon with mysql-test-run.pl

      
        1
      
       cd mysql-test ; 
      
        perl
      
       mysql-test-run.pl
    

New default config file was created as ./my.cnf and

will be used by default by the server when you start it.
You may edit this file to change server settings

ubuntu安装mysql