LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
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 03-05-2004, 04:06 PM   #1
mpgram
Member
 
Registered: Sep 2003
Location: Dallas TX
Distribution: Red Hat
Posts: 59

Rep: Reputation: 15
mysql login permissions


Okay, I have installed mysql. So far so good...

Now, I know this is a linux board, so please don't hurt me...to bad...

I have installed on my Windows box a mysql admin gui. I tried to connect to the mysql server on the linux box, but got user username is not allowed to login from x.x.x.x (my ip address).

How can I change the permissions on the mysql server to accept logins from other IPs?
 
Old 03-05-2004, 07:15 PM   #2
trickykid
LQ Guru
 
Registered: Jan 2001
Posts: 24,149

Rep: Reputation: 235Reputation: 235Reputation: 235
Well, you need to update your user to not only be set locally in the hosts field or column in your tables/db your currently working with or using.

Check out the docs at www.mysql.com as they cover this in their online manual/book, etc.
 
  


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
mysql permissions... jsheffie Linux - Software 1 10-20-2005 02:37 PM
mysql set permissions GraemeK Linux - Software 2 09-27-2004 08:04 AM
restoring mysql databases? and mysql permissions... armegeden Linux - Software 0 03-13-2003 11:04 AM
mysql permissions dai Linux - General 3 02-17-2003 05:00 AM
MySql Permissions... I think matt Linux - General 2 01-24-2002 12:03 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 10:59 PM.

Main Menu
Advertisement
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
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration