How to access remote mysql
来源:互联网 发布:c 从excel导入数据 编辑:程序博客网 时间:2024/05/16 08:50
Quote:
http://benrobb.com/2007/01/15/howto-remote-root-access-to-mysql/
Howto: Remote Root Access to MySql
Veryquickly, another thing that I typically like to do on my server boxesis allow root access to my Mysql database from remote computers. Idon’t forward the port through my router and I use a very securepassword (doesn’t everyone?). I don’t want to create a security risk, Ijust want to connect to the database from other computers around mynetwork – particularly from my laptop.
Again (like most of my instructions) these instructions are for Ubuntu – currently Edgy Eft.
sudo apt-get install mysql-server
Ubuntu installs Mysql at /etc/mysql/ by default. Now we need to set a root password.
mysql -u root
mysql> SET PASSWORD FOR 'ROOT'@'LOCALHOST"
> = PASSWORD('new_password');
Now while we’re still here, we’ll create a new HOST for root and allow root to login from anywhere.
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'
> IDENTIFIED BY 'password' WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES;
mysql> exit
Thanks to Thom for the Flush Privileges comment. I think it dependson other settings in your MySQL setup, since I didn’t have to, but justin case, I’ve added it here. We’re almost done now. We just have totell Mysql to allow remote logins.
sudo vi /etc/mysql/my.cnf
Out-of-the-box, MySQL only allows connections from the localhostidentified by the IP Address of 127.0.0.1. We need to remove thatrestriction, so find the line that says
bind-address = 127.0.0.1
and comment it out. That’s all there is to it! Now get your favorite MySql client and start developing.
- How to access remote mysql
- Remote Access To MySQL
- How Do I Enable Remote Access To MySQL Database Server?
- How to Remote Access Oracle DB
- mysql remote access
- mysql remote access
- How to configure ODBC DSN in Client to access remote DB2 for Windows
- How to access to remote server by root directly on solaris
- How to Allow MySQL Client to Connect to Remote MySQL server
- How to access a Window XP Remote Destop in a ipv6 network
- 12. 开启 mysql remote access
- mysql how to fix Access denied for user 'root'@'localhost'
- How to Add Route to TCP/IP Routing Table With Windows Routing And Remote Access Console or DOS Promp
- Google software allows remote access to PCs
- Remote Access to the Fedora Linux Desktop
- Remote Access to the CentOS Desktop
- Remote Access to IPython Notebooks via SSH
- How to Retrieve Remote MAC Address Programmatically
- C#实现Diffie-Hellman(DH)算法可结合DES用于通信信息加密
- (转)Win2003 防木马、权限设置、IIS服务器安全配置整理
- 文件夹相关操作
- [转] Strategy: Solve Only 80 Percent of the Problem
- 关于三极管
- How to access remote mysql
- 类型转换
- linux下vi编辑器命令大全
- 一群牛人推荐史上最牛的《软件测试》图书
- Eclipse的代码提示小记
- 创意产业的特征
- 上当的基本原理
- 13个坏习惯让IT工作者中过劳
- 内存泄漏