CentOS 5.4编译安装MySQL
来源:互联网 发布:mac dock栏屏幕切换 编辑:程序博客网 时间:2024/05/21 03:57
CentOS 5.4编译安装MySQL
1、安装编译环境
yum install gcc gcc-c++ autoconf automake ncurses-devel make chkconfig
2、下载,解压缩
wget http://mysql.mirror.tw/Downloads/MySQL-5.1/mysql-5.1.53.tar.gz
tar -xzvf mysql-5.1.53.tar.gz
3、编译
./configure --prefix=/usr/local/mysql --enable-assembler --with-unix-socket-path=/usr/local/mysql/tmp/mysql.sock --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --with-extra-charsets=gb2312,gbk,utf8,latin1 --without-debug --with-charset=utf8 --with-collation=utf8_general_ci --with-pthread --enable-static --enable-thread-safe-client
make
make install
4、添加用户,安装数据库
cd /usr/local/mysql/
chown -R mysql:mysql ./
#安装数据库,添加默认mysql配置
./bin/mysql_install_db --user=mysql
cp share/mysql/my-medium.cnf /etc/my.cnf
#下面我们来设置开机启动mysql
cp share/mysql/mysql.server /etc/init.d/mysqld
chkconfig --add mysqld
chkconfig --level 2345 mysqld on
#之后可以用service mysqld start启动,开机会自动启动
#设置root密码
mysqladmin -u root password ‘new-password’
#删除test数据库、匿名帐户
mysql -u root -p mysql> DROP DATABASE test; [删除test数据库]
mysql> DELETE FROM mysql.user WHERE user = ''; [删除匿名帐户]
mysql> FLUSH PRIVILEGES; [重载权限]
- CentOS 5.4编译安装MySQL
- centos编译安装mysql
- centos编译安装MySQL
- Centos中编译安装 Mysql
- Centos下编译安装mysql
- CentOS下编译安装MySQL
- CentOS 源码编译安装MySQL
- CentOS MySQL安装和编译【转帖】
- centos 编译安装php,apache,mysql
- CentOS下编译安装mysql 5.5.10
- CentOS 编译 nginx+php+mysql 安装手记
- CentOS 编译 nginx+php+mysql 安装手记
- CentOS 编译 nginx+php+mysql 安装手记
- centos下 MySQL 5.5.14 编译安装
- centos源码编译安装mysql-5.5.13
- CentOS 6 编译安装Nginx+PHP+Mysql
- CentOS 5.5 编译安装MySQL 5.5
- Centos 5.6编译安装mysql 5.5.11
- 怎样用protel99画原理图后再转用POWER PCB画PCB板
- What is blocker on the road of learning English?
- BlackBerry模拟器支持中文
- dwr配置、入门
- Wireshark图解教程(简介、抓包、过滤器)
- CentOS 5.4编译安装MySQL
- EditPlus正则表达式
- Android 1.6 支持更多的屏幕大小和分辨率
- C#编程序中正确理解下面小图标
- StringBuilder和String的区别
- java与matlab的路径问题
- LAYOUT SHOW
- WNMV
- 用户