Mysql安装

1.安装cmake
yum install cmake
2.安装 bison
yum install bison
2.编译Mysql
tar zxvf cmake-2.8.5.tar.gz
cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql
make && make install
3.配置库
复制配置文件
cp support-files/my-medium.cnf /usr/local/mysql/my.cnf
设置权限
chmod +x /usr/local/mysql
chown -R mysql:mysql /usr/local/mysql
gedit /usr/local/mysql/my.cnf
[mysqld] 添加：
datadir=/usr/local/mysql/data
default-storage-engine=MyISAM
以下可选： r = /usr/local/mysql/mysql_error.log
pid-file = /usr/local/mysql/mysql.pid
user = root
tmpdir = /tmp
安装默认数据表
/usr/local/mysql/scripts/mysql_install_db –basedir=/usr/local/mysql –datadir=/usr/local/mysql/data –user=mysql

问题处理
一、出现以下错误提示：

– 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,

  remove CMakeCache.txt and rerun cmake.On Debian/Ubuntu, package name is libncurses5-dev, on Redhat and derivates it is ncurses-devel.

Call Stack (most recent call first):
cmake/readline.cmake:126 (FIND_CURSES)
cmake/readline.cmake:216 (MYSQL_USE_BUNDLED_LIBEDIT)
CMakeLists.txt:250 (MYSQL_CHECK_READLINE)

– Configuring incomplete, errors occurred!

解决方法：

rm CMakeCache.txt
yum 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
yum install bison
make && make install
二、
ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
在my.cnf文件添加
skip-grant-tables
／etc/init.d/mysql restart
mysql -uroot -p

use mysql;
Database changed
修改root密码
update user set password=password(“123456”) where user=”root”;
授权远程访问
UPDATE user SET Host=’%’ WHERE User=’root’ AND Host=’localhost’ LIMIT 1;
flush privileges;