2024年4月25日发(作者：)
下载并上传至服务器
下载并上传至服务器
rpm -ivh
启动：
rcmysql start
netstat–nat
3306端口打开说明mysql启动了
find /usr/bin -name '*mysql*'
/usr/bin/mysqld_safe
/usr/bin/mysqltest
/usr/bin/mysqld_multi
/usr/bin/mysql_install_db
/usr/bin/mysql_fix_extensions
/usr/bin/mysql_upgrade
/usr/bin/mysql_tzinfo_to_sql
/usr/bin/mysql_setpermission
/usr/bin/mysqlbug
/usr/bin/mysqlhotcopy
/usr/bin/mysql_convert_table_format
/usr/bin/mysqldumpslow
/usr/bin/mysql_plugin
/usr/bin/mysql_secure_installation
/usr/bin/mysql_zap
find -name '*mysqladmin*'
未找到相关命令，说明还不能改变root登陆mysql的密码，故继续安装mysql客户端
rpm -
find /usr/bin -name '*mysql*'
/usr/bin/mysqld_safe
/usr/bin/mysql
/usr/bin/mysqltest
/usr/bin/mysqld_multi
/usr/bin/mysql_install_db
/usr/bin/mysqlimport
/usr/bin/mysql_fix_extensions
/usr/bin/mysql_upgrade
/usr/bin/mysqlaccess
/usr/bin/mysqlcheck
/usr/bin/mysql_tzinfo_to_sql
/usr/bin/
/usr/bin/mysql_setpermission
/usr/bin/msql2mysql
/usr/bin/mysqlbinlog
/usr/bin/mysql_waitpid
/usr/bin/mysqlslap
/usr/bin/mysqlbug
/usr/bin/mysqlhotcopy
/usr/bin/mysql_convert_table_format
/usr/bin/mysqldump
/usr/bin/mysqldumpslow
/usr/bin/mysqlshow
/usr/bin/mysql_plugin
/usr/bin/mysql_secure_installation
/usr/bin/mysql_zap
/usr/bin/mysql_find_rows
/usr/bin/mysqladmin
修改
root
用户
mysql
密码：
mysqladmin-u root password zhuxing
分配所有的权限给某个超级用户
mysql–u root –p
zhuxing
grant all on *.* to 'remoteuser'@'%' identified by 'zhuxing';
开启端口
vi /etc/sysconfig/iptables
add:-A RH-Firewall-1-INPUT -m state --state NEW -m tcp -p tcp --dport3306 -j ACCEPT
/etc/rc.d/init.d/iptables restart
至此安装完成
客户端
客户端安装
登陆语句：
mysql-h 192.168.38.135-uremoteuser–p
zhuxing
发布评论