Download your favorite Linux distribution at LQ ISO.
Go Back > Forums > Linux Forums > Linux - Software
User Name
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.


  Search this Thread
Old 03-05-2004, 04:06 PM   #1
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 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
LQ Guru
Registered: Jan 2001
Posts: 24,149

Rep: Reputation: 245Reputation: 245Reputation: 245
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 as they cover this in their online manual/book, etc.


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 > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 09:28 PM.

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