Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 13-02-2010
Member
 
Join Date: Feb 2010
Posts: 137
question How to remote connections by MySQL database server

Hi all,

I am using CentOS. It is installed in the MySQL database server, the system due to security considerations, the default is not supported by non-native users to connect to the database server, if i want the user to another machine connected to the database server. I just want to know that how to remote connections by MySQL database server. Thanks.
Reply With Quote
  #2  
Old 13-02-2010
Member
 
Join Date: Apr 2008
Posts: 1,948
How to remote connections by MySQL database server

In the console implementation of the mysql-u root-p mysql, the system prompts the user entered into the database root password, enter into the mysql console immediately after the completion of this command the first one is the implementation of the mysql command, and the second is the system data name of the mysql is not the same. Check the process and reply.
Reply With Quote
  #3  
Old 13-02-2010
Member
 
Join Date: May 2008
Posts: 2,008
How to remote connections by MySQL database server

In the mysql console to execute commands in the 'root'@'%' can interpret it this way: root is the user name,% is the host name or IP address, where% represents any host or IP address, you can also replace any other user name or specify a unique IP address; 'MyPassword' is for authorized users to specify the login password for the database; Another point is that I need to note here are authorized for all permissions. Check and reply.
Reply With Quote
  #4  
Old 13-02-2010
Member
 
Join Date: Apr 2008
Posts: 2,001
How to remote connections by MySQL database server

if you can not trust the implementation of the mysql console, select host, user from user; check the contents of a user table. in the mysql console implementation of the GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY' MyPassword 'WITH GRANT OPTION. check the baove procedure and reply me back. Thanks in advance.
Reply With Quote
  #5  
Old 13-02-2010
Member
 
Join Date: Oct 2005
Posts: 2,389
Re: How to remote connections by MySQL database server

You need the root or mysql username and password to log in to MySQL using Telnet or an SSH client. This agree to you to perform question at the command prompt. At the command prompt, type
Code:
mysql -u username -p
Enter password when prompted. Once logged in, you can list all available databases by typing:
Code:
SHOW DATABASES;
Create a Database by typing :
Code:
CREATE DATABASE databasename123;
and add users to a database by typing
Code:
GRANT ALL PRIVILEGES ON databasename123.* TO newuser@"%" IDENTIFIED BY "newpassword";
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How to remote connections by MySQL database server"
Thread Thread Starter Forum Replies Last Post
Issues in C# application connecting to Remote MySQL 5 database. kyosang Software Development 5 25-01-2010 04:24 PM
Mysql Error : Can't connect to local mysql server through socket ' var lib mysql mysql.sock' 2 roshan45 Software Development 3 07-11-2009 09:36 PM
SQL Server does not allow remote connections Bofinn Software Development 3 04-02-2009 06:17 PM
Server 2008 does not allow remote connections thejamie Windows Server Help 1 13-11-2008 05:56 AM
"The client could not connect to the remote computer. Remote connections..." - Server 2003 Maestro Windows Server Help 7 26-10-2007 12:28 AM


All times are GMT +5.5. The time now is 04:11 PM.