LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 03-12-2012, 10:51 AM   #1
jrahma
Member
 
Registered: Oct 2011
Posts: 39

Rep: Reputation: Disabled
1045 mysql access denied for user


Hi,

I have just installed a fresh copy of mysql on a fresh copy of debian.

I am getting:

1045 mysql access denied for user root@192.168.1.9

the .9 is my PC and the server is 192.168.1.1

I am sure about the user id and password..

can anyone help..
 
Old 03-13-2012, 02:14 AM   #2
chrism01
LQ Guru
 
Registered: Aug 2004
Location: Sydney
Distribution: Centos 6.8, Centos 5.10
Posts: 17,254

Rep: Reputation: 2328Reputation: 2328Reputation: 2328Reputation: 2328Reputation: 2328Reputation: 2328Reputation: 2328Reputation: 2328Reputation: 2328Reputation: 2328Reputation: 2328
In mysql you have to specify which machines you can connect from, as well as the user's name & passwd...
https://dev.mysql.com/doc/refman/5.5...eate-user.html
 
Old 03-13-2012, 02:35 AM   #3
jrahma
Member
 
Registered: Oct 2011
Posts: 39

Original Poster
Rep: Reputation: Disabled
but this is installed in a local network for the company and I want it to be accessible for everyone within the network?
 
Old 03-13-2012, 09:13 PM   #4
chrism01
LQ Guru
 
Registered: Aug 2004
Location: Sydney
Distribution: Centos 6.8, Centos 5.10
Posts: 17,254

Rep: Reputation: 2328Reputation: 2328Reputation: 2328Reputation: 2328Reputation: 2328Reputation: 2328Reputation: 2328Reputation: 2328Reputation: 2328Reputation: 2328Reputation: 2328
In that case, use wildcard for the hostname part, as per the examples at that link
 
  


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 Error Nr. 1045 Access denied for user 'root'@'192.168.0.28' (using password: YE uppalagayatri Linux - Software 9 05-11-2011 02:45 PM
MySql ERROR 1045 (00000): Access denied - different MySQL versions paulsm4 Linux - Software 1 03-01-2011 10:27 PM
[SOLVED] mysql ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: 124vikas.dange@gmail.com Linux - Server 4 11-19-2010 02:36 AM
Mysql error 1045: Access denied for user 'root'@'localhost' (using password: YES) visitashu Linux - Server 15 11-11-2010 12:05 AM
mysql server ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using pas tarak420 Linux - Server 2 09-18-2008 10:52 PM


All times are GMT -5. The time now is 12: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