ubuntu下安装mysql(二进制)到自定义目录_MySQL
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了ubuntu下安装mysql(二进制)到自定义目录_MySQL,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含2666字,纯文字阅读大概需要4分钟。
内容图文
Ubuntu bitsCN.comubuntu下安装mysql(二进制)到自定义目录
一,安装
1, 下载 mysql二进制文件: http://dev.mysql.com/downloads/mysql/ 页面,选择linux generic ,然后选择最后一个 “Linux - Generic (glibc 2.5) (x86, 32-bit), Compressed TAR Archive” 进行下载 (32或者64根据是实际情况)
2, 切换到root 用户
3, 先创建一个group和一个属于这个组的user
shell> groupadd group1
shell> useradd -r -g group1 user1
3, 解压下载的二进制包, 到自己要放的位置, 如home/user/mysql
4, cd home/user/mysql
5, 赋予操作权限:
chown -R user1 .
chgrp -R group1 .
6, scripts/mysql_install_db --user=user1 为user1安装数据库 (需要libaio包,使用新德里帮忙下一下)
7, 赋权限:
chown -R root .
chgrp -R group1 .
chown -R root .
chown -R user1 data
8,启动mysql后台服务:
bin/mysqld_safe --user=user1 &
如果没有报错,那么就是服务器的启动成功。
测试一下:
新开一个terminal,
cd home/user/mysql/bin
./mysqladmin version
正确的话 就会显示版本信息之类的 并且没有其他错误报出。
二,增加安全性
cd home/user/mysql
bin/mysql_secure_installation
然后具体步骤的一些 信息如下:
Enter current password for root (enter for none):
OK, successfully used password, moving on...
Setting the root password ensures that nobody can log into the MySQL
root user without the proper authorisation.
Set root password? [Y/n] y
New password:
Re-enter new password:
Password updated successfully!
Reloading privilege tables..
... Success!
By default, a MySQL installation has an anonymous user, allowing anyone
to log into MySQL without having to have a user account created for
them. This is intended only for testing, and to make the installation
go a bit smoother. You should remove them before moving into a
production environment.
Remove anonymous users? [Y/n] y
... Success!
Normally, root should only be allowed to connect from 'localhost'. This
ensures that someone cannot guess at the root password from the network.
Disallow root login remotely? [Y/n] y
... Success!
By default, MySQL comes with a database named 'test' that anyone can
access. This is also intended only for testing, and should be removed
before moving into a production environment.
Remove test database and access to it? [Y/n] y
- Dropping test database...
... Success!
- Removing privileges on test database...
... Success!
Reloading the privilege tables will ensure that all changes made so far
will take effect immediately.
Reload privilege tables now? [Y/n] y
... Success!
三,便利设置
1,将mysql的路径加到环境变量中去:
sudo gedit /etc/profile
然后加入:
1, export MYSQL_HOME=home/user/mysql;
2,在PATH=XX后面加入 :$MYSQL_HOME/bin
bitsCN.com
内容总结
以上是互联网集市为您收集整理的ubuntu下安装mysql(二进制)到自定义目录_MySQL全部内容,希望文章能够帮你解决ubuntu下安装mysql(二进制)到自定义目录_MySQL所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。