Solved

MySQL 5.0.45 - root access on any external, no pass ?

Posted on 2007-11-18
20
1,189 Views
Last Modified: 2010-04-21
Hello everyone

I have read every thread i could find and tried every command i can, i am sure i am doing something wrong or lack of sleep has fried my brain.

brand new 5.0.45 MySQl install, i need to allow access on root from all hosts with no password

i cant get it to work, i can only connect from local host on root...

i tried adding *.* as a host using mysql admin but it seems to do nothing and doesnt allow me to connect from another system

i have tried grant commands, giving grant to root,flush privileges afterwards, but nothing is working for me, this is a test bed system, not accessible from the Inet, i am redoing someone else's work who has no security so for now i need just root access with no password from *.* anywhere.....

Please save what little sannity i have left, i know the question has been asked, but i have tried literally ever response people have given to everyone else :(
0
Comment
Question by:Mathiau
  • 13
  • 4
  • 3
20 Comments
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 20308868
well, let me tell you ROOT with no password for any host is like serving it on the golden plate to hackers...
DON'T do that... it will save you from more severe illness later!!!

why ROOT?
why no password?

0
 
LVL 18

Expert Comment

by:Andrej Pirman
ID: 20308928
First of all, like Angellll says: root with NO password is ...I even do not have an idea how to call such approach!

But if you still want to grant access to all hosts, put "%" instead of "localhost" in Host row of mysql table, and reload privileges.
0
 
LVL 2

Author Comment

by:Mathiau
ID: 20308930
I know it is, why this system isnt accessible to the internet right now, i am well aware of the security issued involved.

the original coder claimed passwords didnt work with his scripts, i have tested some, and some work and some dont, this person also uses global variables (using php with mysql).

So i am just trying to move what i need to a new server, once done, i plan to go back over the coding and fix it so it works with user and passwords, these items wont be seeing the light of day, or the internet, until they are password protected.
0
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 
LVL 18

Expert Comment

by:Andrej Pirman
ID: 20308932
...also, assure firewall is not blocking traffic on port 3306, which is used by MySQL server.
0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 20308936
>the original coder claimed passwords didnt work with his scripts, i
actually, with PHP, having no password will not work, you will have to use a password anyhow.
0
 
LVL 2

Author Comment

by:Mathiau
ID: 20308979
not sure, cause non of his php scripts have password to connect to the mysql DB's and his pages work, not a single one! scary how he got by for 4 years doing this, using root with no passwords to connect tot he DB's, not even IP access was used.


example


$use=$PHP_AUTH_USER;
      $dblink=mysql_connect("**********", "root", "");
      $db_list = mysql_list_dbs($dblink);
            while ($database=mysql_fetch_object($db_list))


all his scripts are like that.
0
 
LVL 2

Author Comment

by:Mathiau
ID: 20309002
Just tried this

grant all privileges on *.* to 'root'@'%';


but now i get the

"Can't find any matching row in the user table"
0
 
LVL 2

Author Comment

by:Mathiau
ID: 20309014
angelIII, could i tbe because of using version of PHP 4 and lower? i know after 4.1? global variables was off by default and other security items changed to make it more out of the gate secure.


0
 
LVL 18

Accepted Solution

by:
Andrej Pirman earned 500 total points
ID: 20309605
It is:
GRANT ALL ON *.* TO 'root'@'%';
FLUSH PRIVILEGES;
or
REVOKE ALL ON *.* TO 'root'@'%';
FLUSH PRIVILEGES;
0
 
LVL 2

Author Comment

by:Mathiau
ID: 20310359
i am still getting the error

Can't find any matching row in the user table

running the GRANT ALL ON *.* TO 'root'@'%';

i am conencting using mySQL Query Browser and then connecting to the mysql folder locally on the machine which the BD is hosted on... am i doing something incorrectly? or is their some restriction on mysql 5.0.45 that wont allow me to grant this access to root?
0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 20310449
>angelIII, could i tbe because of using version of PHP 4 and lower?
yes, that is highly probable!

now, please run this:

mysql> use mysql
mysql> select user, hostname, password from user

and report that it returns (clearing the passwords anyhow).
0
 
LVL 2

Author Comment

by:Mathiau
ID: 20310466
just did a completly reinstall of MySQL, no passwords on root, standard install (still get same error with grant)
 
results from select * from users  ( added the ...)

Host.................................User      ..........................Password
localhost..........................root      
production.......................root      
127.0.0.1.........................root      


0
 
LVL 2

Author Comment

by:Mathiau
ID: 20312524
there are no passwords set also, why they are blank.
0
 
LVL 2

Author Comment

by:Mathiau
ID: 20314832
is it posible i may need to put a password on root before i can allow external access, and if so, can i remove the password after it was been added?
0
 
LVL 2

Author Comment

by:Mathiau
ID: 20317441
didnt work with a password on the root account either, now i am completly lost on this one :( Did MySQL completly block in the program root access on *.* in some new version
0
 
LVL 2

Author Comment

by:Mathiau
ID: 20317762
Did i get everyone stumped on ths as well :)
0
 
LVL 2

Author Comment

by:Mathiau
ID: 20322331
Well, it seems to make this work, this method worked


Put a password on the root account / Apply
Add Hosts from which the user can connect   (*.*)
remove password from root account / apply


done, can now access externally from any host, i did this using MySQL Admin.
0
 
LVL 2

Author Closing Comment

by:Mathiau
ID: 31409830
The solution was correct, but did not seem to apply perfectly to this situation, perhaps this is a new limitation in MySQL 5.0.45 + that you can not give such access with out root having at least a password to start, which is good news of course.
0
 
LVL 18

Expert Comment

by:Andrej Pirman
ID: 20326695
I am glad you solved it. MySQL admin tool can be used for such things, too.
0
 
LVL 2

Author Comment

by:Mathiau
ID: 20363349
this is weird, set up another system and tried the above but it is not working..lol so maybe it was a combo of what i did and some queries, time to test!
0

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
PHP - AJAX and MySQL it works only if the value is a number 12 93
MySQL  on Tomcat 8 94
AWS EC2 & RDS Instance 5 64
Formating field inside mysql query 2 32
As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL (http://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html) several years ago, it seemed like now was a good time to updat…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question