Access to MySql

[Hope]

I am a MySQL apprentice, I downloaded and installed MySQL successfully
on Windows XP, and I can see 2 default database:mysql and test.

The problem is: when I tried to create a new database by
CREATE DATABASE publish;

It showed the message:
ERROR 1044: Access denied for user:'@localhost' to database 'publish'

It looks that I was treated as localhost user, and doesn't have
administrator's previlege (even I logged in as administrator account),
so I can do nothing about mysql, can anybody tell me how to get full
previlege? or how to create database?

Thank you, very much!

[David L]

it looks like you've managed to login as a blank user. The @localhost
is where you're from. You need to see root@localhost.

Hope wrote:

I am a MySQL apprentice, I downloaded and installed MySQL successfully
on Windows XP, and I can see 2 default database:mysql and test.

The problem is: when I tried to create a new database by
CREATE DATABASE publish;

It showed the message:
ERROR 1044: Access denied for user:'@localhost' to database 'publish'

It looks that I was treated as localhost user, and doesn't have
administrator's previlege (even I logged in as administrator account),
so I can do nothing about mysql, can anybody tell me how to get full
previlege? or how to create database?

Thank you, very much!

[Hope]

Hi David,
Thank you for your reply, can you tell me how to see root@localhost,
and what's the next step after that?
Thank you, David
Hope
David L <[e-mail]> wrote in message news:<Dx******************@news-server.bigpond.net.au>...

it looks like you've managed to login as a blank user. The @localhost
is where you're from. You need to see root@localhost.

Hope wrote:

I am a MySQL apprentice, I downloaded and installed MySQL successfully
on Windows XP, and I can see 2 default database:mysql and test.

The problem is: when I tried to create a new database by
CREATE DATABASE publish;

It showed the message:
ERROR 1044: Access denied for user:'@localhost' to database 'publish'

It looks that I was treated as localhost user, and doesn't have
administrator's previlege (even I logged in as administrator account),
so I can do nothing about mysql, can anybody tell me how to get full
previlege? or how to create database?

Thank you, very much!

[Aggro]

Hope wrote:

It showed the message:
ERROR 1044: Access denied for user:'@localhost' to database 'publish'

Start MySQL console like this:

c:\mysql\bin\mysql -u root

Or if you have set password for root user, use:

c:\mysql\bin\mysql -u root -p

After that, you should be able to create databases.

Followups set only to: mailing.database.mysql

[Jeff Silverman]

On Tue, 15 Jun 2004 05:52:58 +0000, Aggro wrote:

Hope wrote:

It showed the message:
ERROR 1044: Access denied for user:'@localhost' to database 'publish'

Start MySQL console like this:

c:\mysql\bin\mysql -u root

Or if you have set password for root user, use:

c:\mysql\bin\mysql -u root -p

After that, you should be able to create databases.

Followups set only to: mailing.database.mysql

I have a similar problem. I have root access on the database server
machine and I can see (and modify) the files in /var/lib/mysql/mysql.
However, I don't know the root password for the database. Is there a way
to set the root mysql password from the linux root account?
Many thanks,
Jeff

[Aggro]

Jeff Silverman wrote:

I have a similar problem. I have root access on the database server
machine and I can see (and modify) the files in /var/lib/mysql/mysql.
However, I don't know the root password for the database. Is there a way
to set the root mysql password from the linux root account?

Yes:
http://dev.mysql.com/doc/mysql/en/Re...rmissions.html

[David L]

hi, i trust Aggro's response would have covered it. (sorry i don't read
post very often).

Hope wrote:

Hi David,
Thank you for your reply, can you tell me how to see root@localhost,
and what's the next step after that?
Thank you, David
Hope
David L <[e-mail]> wrote in message news:<Dx******************@news-server.bigpond.net.au>...

it looks like you've managed to login as a blank user. The @localhost
is where you're from. You need to see root@localhost.

Hope wrote:

I am a MySQL apprentice, I downloaded and installed MySQL successfully
on Windows XP, and I can see 2 default database:mysql and test.

The problem is: when I tried to create a new database by
CREATE DATABASE publish;

It showed the message:
ERROR 1044: Access denied for user:'@localhost' to database 'publish'

It looks that I was treated as localhost user, and doesn't have
administrator's previlege (even I logged in as administrator account),
so I can do nothing about mysql, can anybody tell me how to get full
previlege? or how to create database?

Thank you, very much!

[Hope]

Thank you, guys, I can work well with mySQL now.
Best regards,

Hope

Aggro <sp**********@yahoo.com> wrote in message news:<_8*************@read3.inet.fi>...

Hope wrote:

It showed the message:
ERROR 1044: Access denied for user:'@localhost' to database 'publish'

Start MySQL console like this:

c:\mysql\bin\mysql -u root

Or if you have set password for root user, use:

c:\mysql\bin\mysql -u root -p

After that, you should be able to create databases.

Followups set only to: mailing.database.mysql