mysql5.5.8安装

来源：互联网发布：python网络编程知乎编辑：程序博客网时间：2024/06/06 03:23

一、Centos安装环境准备：

yum –y install cmake bison bzr

二、安装mysql

tar zxvf mysql-5.5.8.tar.gz

cd mysql-5.5.8

cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DINSTALL_DATADIR=/usr/local/mysql/data -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DEXTRA_CHARSETS=all -DWITH_EMBEDDED_SERVER=1 -DENABLED_LOCAL_INFILE=1 -DWITH_MYISAM_STORAGE_ENGINE=1 -DMYSQL_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:256 (MYSQL_CHECK_READLINE)

解决办法：

安装ncurses-devel：

yum –

y install ncurses-devel

#find / -name CMakeCache.txt //查找所有CMakeCache.txt 文件命令会显示下列内容

找到文件后使用rm –f 将该文件删除。再执行cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DINSTALL_DATADIR=/usr/local/mysql/data -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DEXTRA_CHARSETS=all -DWITH_EMBEDDED_SERVER=1 -DENABLED_LOCAL_INFILE=1 -DWITH_MYISAM_STORAGE_ENGINE=1 -DMYSQL_USER=mysql

即可通过

make

make install

说明：

-DCMAKE_INSTALL_PREFIX=/usr/local/mysql //安装目录

-DINSTALL_DATADIR=/www/mydata //数据库存放目录

-DDEFAULT_CHARSET=utf8 //使用utf8字符

-DDEFAULT_COLLATION=utf8_general_ci //校验字符

-DEXTRA_CHARSETS=all //安装所有扩展字符集

-DWITH_SSL=system //使用SSL加密

-DWITH_EMBEDDED_SERVER=1 //编译成embedded mysql library

-DENABLED_LOCAL_INFILE=1 //允许从本地导入数据

-DWITH_MYISAM_STORAGE_ENGINE=1 //安装myisam引擎

三、配置mysql

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

vim /etc/my.cnf

在my.cnf中增加用户名及数据目录

在[mysqld]下面增加:

user=mysql

datadir=/usr/local/mysql/data

并将记录mysql操作的日志注释掉，如下：

#log-bin=mysql-bin

#binlog_format=mixed

安装mysql初使化系统表其数据

cd /usr/local/mysql

./scripts/mysql_install_db --user=mysql

配置mysqld服务，并使其开机自运行

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

chmod +x /etc/init.d/mysqld

chkconfig --add mysqld

chkconfig mysqld --level 3 on

修改/etc/init.d/mysqld相关配置

vim /etc/init.d/mysqld

将datadir指定为/usr/local/mysql/data

将basedir指定为/usr/local/mysql

basedir=/usr/local/mysql

datadir=/usr/local/mysql/data

mysqld_pid_file_path=/usr/local/mysql /mysql.pid(可选)

启动mysql及指定mysql root密码

service mysqld start

./bin/mysqladmin -u root password 'XXXXXX'

如有报错“-bash mysql command not find”

解决办法：# ln -s /usr/local/mysql/bin/mysql /usr/bin

登陆：mysql –u root –p 回车后输入密码XXXXXX

配置远程访问：

# mysql -u root mysql

mysql> use mysql;

mysql> grant all on *.* to root@'%' identified by 'XXXXXX';

mysql> FLUSH PRIVILEGES;

mysql> quit

# service mysqld restart

0 0