linux环境下mysql编译安装历程_怎么样才能恢复数据

日期:2014-07-26 / 人气: / 来源:网络

shell> cp mysql-5.5.28.tar.gz /usr/local/ mysql-5.5.28.tar.gz
shell> tar -zxvf mysql-5.5.28.tar.gz
shell> ln -s mysql-5.5.28 mysql
shell> cd mysql
shell> cmake .
---------------------
若运行 cmake报错Curses library not found 是因为 curses库没有安装,执行下面的语句即可
shell> yum -y install ncurses-devel
如果上述命令的结果是no package,则使用下面的命令安装
shell> apt-get install libncurses5-dev
----------------------
shell> make
shell> make install
# End of source-build specific instructions
# Postinstallation setup
shell> cd /usr/local/mysql
shell> chown -R mysql .
shell> chgrp -R mysql .
shell> scripts/mysql_install_db --user=mysql #若提示权限不够,用命令:bash scripts/mysql_install_db --user=mysql
shell> chown -R root .
shell> chown -R mysql data
# Next command is optional
shell> cp support-files/my-medium.cnf /etc/my.cnf
shell> bin/mysqld_safe --user=mysql &
shell> bin/mysqladmin -uroot password 123456
shell> bin/mysql -uroot -p #输入此命令后,会提示你输入root用户密码123456(当然了,实际使用时密码不要设置这么简单!),
# Next command is optional
shell> cp support-files/mysql.server /etc/init.d/mysqld
shell> chkconfig --add mysqld
以后启动/停止数据库就可以使用下面的命令:
/etc/init.d/mysqld start #若提示权限不够,用命令:bash /etc/init.d/mysqld start
/etc/init.d/mysqld stop  #若提示权限不够,用命令:bash /etc/init.d/mysqld stop
登录
/usr/local/mysql/bin/mysql -uroot -p

在CentOS系统使用MySQL Workbench图文教程

mysql和 mysq lserver装好以后就可以装workbench了。step1:到mysql的官网上下载workbench安装文件,会提示需要额外安装的package,点击install就好。

MySQL,CentOS,Workbench

作者:管理员




现在致电4006-2991-90 OR 查看更多联系方式 →

Go To Top 回顶部