Gonna put mysql where all crap software goes!!!!

[nochay]

This does it. I have tried everything with mysql, and i am verrrrrrrrrrrrrrrrrrrrrrry close to dumping it in the trash can next to those crappy metacreations products!!!!

After attacking the docs for the bloatware, and looking for countless tutorials, I can't find anything!!!

How do I get rid of this error?

ERROR 1045: Access denied for user: 'edselman@127.0.0.1' (Using password: YES)

also, would this be how to install a sql database? What about tables?

mysql -u <username> -p<password> <database_name> < sql/xcart.sql

Windows 2000 Server
IIS 5.0
PHP 4.0.?

Those are my specs. I am soooooo at wits end with this junk. Please help!!!!

[gothic]

Originally posted by nochay

How do I get rid of this error?

ERROR 1045: Access denied for user: 'edselman@127.0.0.1' (Using password: YES)

Do you have an entry in your 'mysql' DB for that username and hostname? (And that password)

[crouse]

You might try getting "mysqladmin" and see if you can use that to create a user with the correct permissions for the database.

hth's

[nochay]

Thanks guys. I'll try these options.

Dane

(testing new signature )

[Carl-cox-]

also set yr DNS to localhost

[AirmanRules]

first of all, did you started the mysql server before accessing the client?

did you installed mysql as a service?

because if mysql server is down, mysql will never let you enter...

that seems to be the error...

then, if server is up, we have to check if root have password, and then, create the new acounts using insert into users query...

as someone suggested me, you can use mysql control center, a gui for virtually do anything in mysql available for download at www.mysql.com in the download section.

i also recommend you to read the documentation of mysql in your installation or in the web page... that is the official tutorial of mysql.

mysql is great, but is hard to understand...

good luck!

[e980238]

phpmyadmin is a good program too, I might add

[AirmanRules]

ok... i see...

the sintax of your statement may be wrong...

i'm not so sure cuz i'm not an expert, but the safest and easiest way to achieve the same is

mysql -u (username) -p (database) (anything else)

--you don't have to include the password in your statement... mysql will ask for it then later...

hope it solves the puzzle...
Airman

oh... i forgot to tell you mysqladmin works the same way as mysql with the statements...

[AirmanRules]

the other way is by getting into mysql and then type

use (database) ->(press enter)

\. (file-to-execute.sql)->(press enter)

that's even more secure... but a little bit longer.

Airman

[AirmanRules]

to create a database, simply type:

CREATE DATABASE (DATABASE NAME);

TO CREATE TABLES USE THE SQL SYNTAX.

see ya;

Airman