Re: Error 1044 Access denied to database
From: Aggro (spammerdream_at_yahoo.com)
Date: 06/06/04
- Next message: jos.de.nijs_at_f1help.org: "2 Websites on 1 url"
- Previous message: Dominik: "Re: Right-click menu change"
- In reply to: John: "Error 1044 Access denied to database"
- Next in thread: bill: "Re: Error 1044 Access denied to database"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Sun, 06 Jun 2004 16:42:59 GMT
John wrote:
> If you can help me I'd be very grateful. I think that something must
> be wrong or amiss with the settings or the paths to the files in
> my.ini file? Or perhaps it is just a bug with php or MySql?
It is not a bug, and it has nothing to do with php, so alt.php,
alt.comp.lang.php and comp.lang.php groups are not concerned about this
problem.
And even if this would be problem for php also, don't post to several
different newsgroups. Pick one group and one group only and post your
question to there. If you fail to get help from there, think again was
the group selection good or bad and did you ask the question properly.
If you think yes, then you can try another group. Why you should do
this? Because many people don't usually even bother to answer people who
post the question into many newsgroups, because it is against the
netiquette. This is only a friendly advice, because you might not know
this "rule". Don't be offended by me reminding it.
Now, to your problem.
When you installed MySQL you had a root account at the very beginning.
You might have changed the password for it, but if you havent, the
password is empty. The root user has privileges to do anything in the
database, while test user (which is the user you seem to have logged in,
has privileges only in the "test" database.) Try to start your mysql
console program like this:
mysql -u root
If you can get in, you don't have a root password, but that doesn't
matter with this problem. When you get in, try to type the command you
tried earlier:
source C:\mysql\newland_tours.sql
It should not give the same error anymore.
Follow-ups set to mailing.database.mysql only
- Next message: jos.de.nijs_at_f1help.org: "2 Websites on 1 url"
- Previous message: Dominik: "Re: Right-click menu change"
- In reply to: John: "Error 1044 Access denied to database"
- Next in thread: bill: "Re: Error 1044 Access denied to database"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
|
