LinuxQuestions.org
Support LQ: Use code LQ3 and save $3 on Domain Registration
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices

Reply
 
Search this Thread
Old 07-17-2011, 08:54 AM   #1
mpapet
Member
 
Registered: Nov 2003
Location: Los Angeles
Distribution: debian
Posts: 453

Rep: Reputation: 46
mysql-server root connects, no other account does


Hi,

I'm running Debian Testing and am confounded by a new problem.

mysql -u root -p works great.

mysql -u mythtv -p doesn't. This is a first for me.

I did the usual as mysql root:
mysql> create user 'mythtv'@'127.0.0.1' identified by 'mythtv';
Query OK, 0 rows affected (0.01 sec)

mysql> grant all on *.* to 'mythtv'@'127.0.0.1';
Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)


Here's the user in the mysql user table:
| Host | User | Password | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | Show_db_priv | Super_priv | Create_tmp_table_priv | Lock_tables_priv | Execute_priv | Repl_slave_priv | Repl_client_priv | Create_view_priv | Show_view_priv | Create_routine_priv | Alter_routine_priv | Create_user_priv | Event_priv | Trigger_priv | ssl_type | ssl_cipher | x509_issuer | x509_subject | max_questions | max_updates | max_connections | max_user_connections |

| 127.0.0.1 | mythtv | *CC8F35F587CA5A556B4132C2407E556D92172FFC | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | N | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | | | | | 0 | 0 | 0 | 0 |

I did the same old login,
mysql -u mythtv -p
Enter password:
ERROR 1045 (28000): Access denied for user 'mythtv'@'localhost' (using password: YES

What logging options do I use to figure out why it's being denied?

Thanks
 
Old 07-17-2011, 11:23 AM   #2
tronayne
Senior Member
 
Registered: Oct 2003
Location: Northeastern Michigan, where Carhartt is a Designer Label
Distribution: Slackware 32- & 64-bit Stable
Posts: 3,118

Rep: Reputation: 818Reputation: 818Reputation: 818Reputation: 818Reputation: 818Reputation: 818Reputation: 818
Perhaps try (this makes mythv and administrative user)
Code:
grant   all privileges on *.*
to      'mythtv'@'localhost' identified by 'mythtv' with grant option;

grant   all privileges on *.*
to      'mythtv'@'%' identified by 'mythtv' with grant option;

flush   privileges;
The "grant all privileges" above creates the user.

It looks like you want "Atila the Hun" permissions for user mythtv; otherwise delete the with grant option part from the above.

Hope this helps some.
 
Old 07-18-2011, 10:19 AM   #3
mpapet
Member
 
Registered: Nov 2003
Location: Los Angeles
Distribution: debian
Posts: 453

Original Poster
Rep: Reputation: 46
Quote:
Originally Posted by tronayne View Post
Perhaps try (this makes mythv and administrative user)
Code:
grant   all privileges on *.*
to      'mythtv'@'localhost' identified by 'mythtv' with grant option;

grant   all privileges on *.*
to      'mythtv'@'%' identified by 'mythtv' with grant option;

flush   privileges;
The "grant all privileges" above creates the user.

It looks like you want "Atila the Hun" permissions for user mythtv; otherwise delete the with grant option part from the above.

Hope this helps some.
Yeah, I figured I'd start with the loosest possible permissions and backtrack when I got the client issues sorted out.

The final answer was to reset the password per the example below. Why? Dunno.

UPDATE mysql.user SET Password=PASSWORD('newpass')
WHERE User='bob' AND Host='%.loc.gov';
FLUSH PRIVILEGES;

Last edited by mpapet; 07-18-2011 at 10:32 AM.
 
  


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
Internal network static IP, dyndns account connects to wrong home server Brian5 Linux - Networking 2 10-02-2007 09:32 PM
is it legitimate and allowed and can be done to make another user account set uid and gid to null 0 to make another root account with different name and possibly not damage the debian system creating and using that new account BenJoBoy Linux - Newbie 12 01-29-2006 11:02 AM
URGENT (server down) : All account disabled ! (and also root) jmcollin92 Mandriva 2 01-10-2006 04:57 PM
MySQL deleted root account and can't re-install... ivj Linux - Software 2 07-09-2004 11:51 PM
Fixing MySQL root account permissions. TexasDex Linux - Software 2 02-02-2004 10:39 PM


All times are GMT -5. The time now is 03:05 PM.

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