当前位置:首页>开发>正文

如何在linux上安装mysql linux中怎么安装mysql

2023-05-19 23:39:09 互联网 未知 开发

 如何在linux上安装mysql linux中怎么安装mysql

如何在linux上安装mysql

//•安装mysql,并启动之,然后给mysql的root账号设密码
# groupadd mysql
# useradd -m mysql -g mysql -d /usr/local/mysql
#tar xvfz mysql-5.0.87.tar.gz
#cd mysql-5.0.8#./configure --prefix=/usr/local/mysql --localstatedir=/home/var --with-charset=utf8 --with-extra-charsets=all --with-berkeley-db --with-innodb --without-readline --enable-assembler --with-pthread --enable-thread-safe-client --with-client-ldflags=-all-static
#make
#make install
#检查/etc/my.cnf是否存在,若存在则修正里面的路径指向,否则数据库表文件可能不装在/home/var下

#/usr/local/mysql/bin/mysql_install_db --user=mysql
#chown -R mysql:mysql /home/var //设权限否则后面的mysqld_safe无法执行
#/usr/local/mysql/bin/mysqld_safe --user=mysql &
#cp ./support-files/mysql.server /etc/rc.d/init.d/mysql //以下两行:设置mysql自启动
#chmod x /etc/rc.d/init.d/mysql
#chkconfig --add mysql
//把mysql加到服务列表中, --add后面如果是mysql系统就会找/etc/rc.d/init.d/mysql
#service mysql start
#/usr/local/mysql/bin/mysqladmin -u root password stoneage#cd /usr/local/include //建立快捷连接 /usr/local/include/mysql -> /usr/local/mysql/include
# ln -s /usr/local/mysql/include/mysql mysql

linux中怎么安装mysql

groupadd mysql
useradd -g mysql mysql -s /sbin/nologin -M
tar -xvzf mysql-5.1.59.tar.gz -C /usr/local/src/
cd /usr/local/src/mysql-5.1.5./configure --prefix=/usr/local/mysql --enable-assembler --with-extra-charsets=complex --enable-thread-safe-client --with-big-tables --with-readline --with-ssl --with-embedded-server --enable-local-infile --with-plugins=innobase --with-client-ldflags=-all-static --with-mysqld-ldflags=-all-static
make&&make install
cp /usr/local/mysql/share/mysql/mysql.server /etc/init.d/mysqld
cp /usr/local/mysql/share/mysql/my-medium.cnf /etc/my.cnf
cd /usr/local/mysql
chown -R mysql .
chgrp -R mysql .
bin/mysql_install_db --user=mysql --skip-external-locking
chown -R root .
chown -R mysql var
bin/mysqld_safe --user=mysql &
export PATH=$PATH:/usr/local/mysql/bin/

/usr/local/mysql/bin/mysql_secure_installation

linux怎么安装mysql

linux安装需要安装着四个包,直接挂载光盘、进入软件包目录安装就行了
MySQL-shared //共享库
MySQL-shared-compat //兼容包
MySQL-server //服务端程序
MySQL-client //客户端工具

最新文章