LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices

Reply
 
Search this Thread
Old 06-13-2005, 09:38 AM   #1
cpopham
LQ Newbie
 
Registered: Jun 2005
Location: wv
Posts: 4

Rep: Reputation: 0
MySql on Linux Remote Login


I am just starting out with Linux and have now installed MySql on it. I can log into the MySQL, but now I want to add a user which can access the MySql server from several different locations.

This is what I have tried at the MYSQL prompt and keep getting an sql error on:
Code:
GRANT ALL PRIVILEGES ON *.* TO myUser@% INDENTIFIED 
     BY 'myPassword';
Any ideas?

Thanks, Chester
 
Old 06-13-2005, 10:14 AM   #2
AdamJacobMuller
LQ Newbie
 
Registered: Jun 2005
Posts: 5

Rep: Reputation: 0
you need to quote strings, such as the username.
Try:
GRANT ALL PRIVILEGES ON *.* TO 'myUser'@% INDENTIFIED
BY 'myPassword';
 
Old 06-13-2005, 10:32 AM   #3
cpopham
LQ Newbie
 
Registered: Jun 2005
Location: wv
Posts: 4

Original Poster
Rep: Reputation: 0
That did the trick, but I am still not able to log into mySQL server externally. When it is on a Windows box, all i need is the Host name of the box MySql is on, a user and password for mysql. When I try it with MySql on Linux, I get an error of host not found. I checked the hostname of the Linux box and it is correct. I read something about that I may need to enable SSH tunneling or something on the Linux box to allow external connections, what is that all about and how would I accomplish that? Any ideas of how I can connect externally would eb appreciated.
Thanks, Chester
 
Old 06-13-2005, 11:19 AM   #4
AdamJacobMuller
LQ Newbie
 
Registered: Jun 2005
Posts: 5

Rep: Reputation: 0
Depending on your server version and the version the client is using you may be affected by this:
http://dev.mysql.com/doc/mysql/en/old-client.html
Basically the mysql dev team changed the default password format to something more secure in the latest release. This, unfortunately, broke many legacy (and some not-so-legacy) clients. There are instructions on how to work around the issue on that page.
 
Old 06-13-2005, 12:01 PM   #5
kiss_linux
Member
 
Registered: Mar 2005
Location: Calgary Canada
Distribution: Mandriva 10 / LE 2005
Posts: 46

Rep: Reputation: 15
Things will get very easy if you install webmin, goto MySQL server and change user permission -> host any
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How To Use Windows Laptop For Remote Login On Linux Mandrake 9.2 danny_beta_read Linux - Laptop and Netbook 1 08-21-2005 07:53 PM
To install ZipSlack, and need to remote login in WinXP to the Linux machine sandugo Slackware 17 05-03-2005 11:10 AM
remote x login instead of local login mandrake-n00b Mandriva 0 04-22-2005 09:19 PM
how to remote login to linux GUI from windows box rfkhickory Linux - Networking 3 10-20-2003 02:21 PM
Exceed - remote login to Linux (graphical) Beuzekom Linux - Software 7 10-20-2003 01:43 PM


All times are GMT -5. The time now is 06:31 AM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration