ubuntu安装mysql

1.  安装cmake:  sudo apt-get install cmake

2.安装MySQL5.5

a)       下载:sudo wget http://cdn.mysql.com/Downloads/MySQL-5.5/mysql-5.5.40.tar.gz

b)       解压并进入目录: sudo tar zxvf mysql-5.5.40.tar.gz && cd mysql-5.5.40

c)       编译安装:

cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql/ -DMYSQL_DATADIR=/root/mysql/data/ -DMYSQL_UNIX_ADDR=/tmp/mysqld.sock -DWITH_INNOBASE_STORAGE_ENGINE=1 -DENABLED_LOCAL_INFILE=1 -DMYSQL_TCP_PORT=3306 -DEXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DMYSQL_UNIX_ADDR=/tmp/mysql.sock -DMYSQL_USER=mysql -DWITH_DEBUG=0

------------

sudo cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql/ -DMYSQL_DATADIR=/home/wkubuntu/mysql/data/ -DMYSQL_UNIX_ADDR=/tmp/mysqld.sock -DWITH_INNOBASE_STORAGE_ENGINE=1 -DENABLED_LOCAL_INFILE=1 -DMYSQL_TCP_PORT=3306 -DEXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DMYSQL_UNIX_ADDR=/tmp/mysql.sock -DMYSQL_USER=mysql -DWITH_DEBUG=0

【常见错误一:Make Error at cmake/readline.cmake:83 (MESSAGE):

  Curses library not found.  Please install appropriate package,
      remove CMakeCache.txt and rerun cmake.On Debian/Ubuntu, package name is libncurses5-dev, on Redhat and derivates it is ncurses-devel.】
--------------------------------------------------------------------------------------------------------------------------------------------------
解决方案:

删除:CMakeCache.txt($:rm CMakeCache.txt);

如果系统是Ubuntu,安装libncurses5-dev($:apt-get install libncurses5-dev );

如果系统是CentOS,安装ncurses-devel(yum install ncurses-devel)

********

【常见错误二:-- Could NOT find Curses (missing:  CURSES_LIBRARY CURSES_INCLUDE_PATH)
CMake Error at cmake/readline.cmake:82 (MESSAGE):
  Curses library not found.  Please install appropriate package,】

------------------------------------------------------------------------

[root@localhost mysql-5.5.11]# rm CMakeCache.txt
[root@localhost mysql-5.5.11]# yum install ncurses-devel 【apt-get install ncurses-devel】
Warning: Bison executable not found in PATH
-- Configuring done
-- Generating done
-- Build files have been written to: /software/mysql-5.5.11

[root@localhost mysql-5.5.11]# yum install bison【apt-get install bison】

 

[常见错误三:CMAKE_CXX_COMPILER not set, after EnableLanguage CMake Error: Internal CMake error, TryCompile confi ]

解决方案:

sudo apt-get install g++

 

出现各种错误之后, rm -rf mysql-5.5.40 删掉之后重新编译即可。

d)make

e)make install

f)       配置

sudo cp support-files/my-medium.cnf /etc/my.cnf

sudo cp support-files/mysql.server /etc/init.d/mysqld

sudo chmod 755 /etc/init.d/mysqld

e)       初始化MySQL

  1.  groupadd mysql     //创建mysql组
  2. useradd -g mysql mysql //创建mysql用户添加到mysql组
  3. sudo sh ./scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql/ --datadir=/home/wkubuntu/mysql/data/

三、    启动和停止MySQL

sudo /etc/init.d/mysqld start

sudo /etc/init.d/mysqld stop

【常见错误4:Couldn't find MySQL server (/usr/bin/mysqld_safe)】

-------------------------

解决方案:sudo rm /etc/mysql/my.cnf

【  MySQL: Starting MySQL….. ERROR! The server quit without updating PID file解决方法】

  cd /usr/local/mysql/

 chown -R mysql:mysql .

[root@localhost mysql]# su - mysql

[mysql@localhost ~]$ cd /usr/local/mysql

[mysql@localhost mysql]$ scripts/mysql_install_db

/usr/local/mysql/bin/mysqld_safe --user=mysql &

b)       安装连接MySQL客户端

sudo apt-get install mysql-client

c)       连接MySQL测试

mysql –u root

-------------------------------------------

The program 'mysql' can be found in the following packages: 
* mysql-server-core-5.1 
* mysql-cluster-server-5.1 
* mysql-server-core-5.0 
Try: apt-get install <selected package> 

并不是真的错误而不错 

是因为编译安装mysql的 

mysql/bin目录没有添加到path里面 

所以要cd 到mysql/bin目录下然后 ./mysql  或者 .bin/mysql -uroot -p

【注:直接进入目录cd /usr/local/ 然后  sudo ./mysql -uroot -p】

 

 

参考文章:http://www.itpub.net/forum.php?mod=viewthread&tid=1811682&highlight=

 

---------------------------------------------

常见错误-bash: mysql: command not found

mysql命令不能用

解决方案:ln -s /usr/local/mysql/bin/mysql /usr/bin

 


.. * The server quit without updating PID file (/home/wkubuntu/mysql/data/iZ25xi5chxrZ.pid).

没解决。。

posted @ 2015-01-19 12:25  kin2321  阅读(610)  评论(0编辑  收藏  举报