Re: Can no connects to mySQL database

mistral wrote:
"Jerry Stuckle wrote:
"

mistral wrote:

"Erwin Moller wrote:
"


mistral wrote:



phpMyAdmin 2.6.2 problem: can no connects to mySQL database: each time
shown error #1045 - Access denied for user 'username'@'192.168.1.2'
(using password: YES)
Is seems, this is most common problem for mySOL and phpMyAdmin.
Extremelly ugly and inconvenient program.

Why use it if you think it stinks?
Go find a better tool or write your own as Jerry suggested.
Personally I think it is very lame to complain about programs given to you
by serious programmers for free to do with as you like.
It is completely fine that you don't like them, but don't complain to us
about it. I know a lot of happy mySQL and phpmyadmin users.

But yes, it is a common problem, but it only happens to a certain kind of
user.
My bet is you are one of those 'too advanced programmers' that don't have
need to read the documentation, and want to 'point and click' the same way
you start up your outlook. Reading documentation is for dull and dusty
COBOL programmers, isn't it?

Go RTFM and all your problems will be solved.
And please don't insult the makers by calling their software ugly and
inconvenient. They didn't deserve that.

Regards,
Erwin Moller

---------------

This is a bug, mySQL code bug. Anyone have ideas how to solve bug
quickly? I can no access mySQL via phpMyAdmin. Need just php sccript
that will do patching of buggy code (all this config, etc, etc)


Read the instructions, set up MySQL security properly and you will be
able to access it. It's that simple.

Of course, you also need to ensure that if you're accessing MySQL from a
remote machine that MySQL networking is enabled, also.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@xxxxxxxxxxxxx
==================


Have read user complaints for this defect:
http://dev.mysql.com/doc/refman/5.0/en/access-denied.html

No one know about this permanents defects and bugs, its not possible to
adjust this at all. Only at random, this may help, may not help. I dont
work at random. Very inconvenient software, the only one plus its GPL,
free. But this just an example that not all GPL software is good. Its
not possible configure it remotely on virtual hosting , since i can no
connects to this phpMyAdmin.


Did you actually read this page? These are not user complaints. This is generated by the MySQL team to help people who don't read the directions set it up properly. Every one of these is caused by MySQL not being set up properly. And every one of them has a solution associated with it.

Excellent work by the MySQL team, IMHO. They have the user in mind.

And I don't know why you can't connect. I have several MySQL systems I manage remotely. It works quite well. So do may other webmasters I know.

And I agree MySQL is not good software. It is EXCELLENT SOFTWARE. But it is a very versatile RDB, and you need to set it up properly to get it to work.

But you don't like it. Fine. Spend the big bucks and get MSSQL, Oracle or DB2. Or write your own to suit your needs.

But don't come here and complain how bad it is. You will get no sympathy from most of the users here. We know better.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@xxxxxxxxxxxxx
==================
.

Relevant Pages

  • Re: Can no connects to mySQL database
    ... this is most common problem for mySOL and phpMyAdmin. ... I know a lot of happy mySQL and phpmyadmin users. ... My bet is you are one of those 'too advanced programmers' that don't have ...
    (comp.lang.php)
  • Re: Can no connects to mySQL database
    ... And what issues do their developers "not know how to correct"? ... Why MySQL need have more security than FTP programs?(that works ... this has nothing to do with phpMyAdmin. ...
    (comp.lang.php)
  • Re: phpMyAdmin installation problem
    ... > Hello Henry! ... > Ok, no foreign party software besides phpMyAdmin, that limits the ... >> control user and pass and grants in mysql, select cookie, start mysql, ... > config.inc.php file by accident. ...
    (Fedora)
  • Re: Can no connects to mySQL database
    ... "Jerry Stuckle wrote: ... this is most common problem for mySOL and phpMyAdmin. ... I know a lot of happy mySQL and phpmyadmin users. ... My bet is you are one of those 'too advanced programmers' that don't have ...
    (comp.lang.php)
  • Re: Wamp help! mySQL wont start
    ... I have copied the Coppermine folder in the www wamp folder and named it something like "MyPhotoAlbum". ... Version de MySQL: ... But if I launch the "start Wamp server" I get a fatal error of the CLI that makes it shut down. ...
    (alt.php)