centos mysql 安装以及远程登录的开启
来源:互联网 发布:淘宝宝贝自定义属性 编辑:程序博客网 时间:2024/05/16 04:58
1.先到官网下载以下包,并解压编译安装
./configure
make
make install
bison
cmake
make
bzr
2.开始搞mysql
cmake
make
bzr
2.开始搞mysql
tar zxvf mysql-5.5.25.tar.gz
cd mysql-5.5.25
cmake . \
-DCMAKE_INSTALL_PREFIX=/mysql/mysqldir \
-DMYSQL_DATADIR=/mysql/mysqldir/data \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DMYSQL_TCP_PORT=3306 \
-DMYSQL_UNIX_ADDR==/mysql/mysqldir/data/mysql.sock \
-DMYSQL_USER=mysql \
-DWITH_DEBUG=0
报错(如无报错直接make & make install 即可):
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)
-- Configuring incomplete, errors occurred!
缺少包:ncurses-devel
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)
-- Configuring incomplete, errors occurred!
缺少包:ncurses-devel
解决:rpm -ivh ncurses-devel*.rpm
或者 yum install ncurses-devel*.rpm
rm -f CMakeCache.txt
cmake . \
-DCMAKE_INSTALL_PREFIX=/mysql/mysqldir \
-DMYSQL_DATADIR=/mysql/mysqldir/data \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DMYSQL_TCP_PORT=3306 \
-DMYSQL_UNIX_ADDR==/mysql/mysqldir/data/mysql.sock \
-DMYSQL_USER=mysql \
-DWITH_DEBUG=0
make
make install
完成后进入MYSQL安装目录
cd /mysql/mysqldir
cp support-files/my-huge.cnf /etc/my.cnf
vi /etc/my.cnf
将数据目录和套接字文件修改为实际值.
修改权限
chown mysql:mysql /etc/my.cnf
chown -R mysql:mysql /mysql/mysqldir
切换用户进入安装目录
su - mysql
cd /mysql/mysqldir
cp scripts/mysql_install_db .
./mysql_install_db
启动MYSQL
bin/mysqld_safe &
cd /mysql/mysqldir
cp scripts/mysql_install_db .
./mysql_install_db
启动MYSQL
bin/mysqld_safe &
- centos mysql 安装以及远程登录的开启
- 开启MySQL的远程登录
- 安装mysql后,开启远程登录
- 安装mysql后,开启远程登录
- mysql安装且开启远程登录
- Mysql 开启远程登录
- mysql 开启远程登录
- Mysql开启远程登录
- 开启mysql远程登录
- MySQL开启远程登录
- CentOS安装mysql并授权远程登录
- CentOS安装mysql并授权远程登录
- mysql开启远程登录访问
- mysql开启远程登录权限
- MySQL开启远程登录访问
- mysql开启远程登录权限
- CentOS 6.5安装LAMP,并开启MySQL远程访问
- centos mysql开启远程访问
- CDialog::OnOk()作用
- 点击调试时提示"MFC不包含调试信息"
- 在给函数传递实参时,不能对用到引用的传NULL
- VC++ ADO操作总结
- 出现警告"defaultlib "library" conflicts with use of other libs; use /NODEFAULTLIB:library ."
- centos mysql 安装以及远程登录的开启
- C语言编程之道-收尾。
- 写给IT新人的忠告,……苦逼程序员
- 蓄水池抽样
- JavaScript/jQuery WebIM 及时聊天通信工具 本地客户端
- _CommandPtr未声明的标识符解决办法
- 经典手机app
- 有问题了,重装?解决?
- DataGrid方法标注