ERROR 1045: Access denied for user: '@localhost' (Using password: NO)

tuf-web_co_uk

i am trying to create a new user on my local computers mysql but i cant seem to get the access can someone please help?!

ERROR 1045: Access denied for user: '@' (Using password: NO)

thanks Jon

Mordecai

Whenever you set up MySQL, you may have set up a username and password. When you connect, you connect like this:
mysql_connect(address of server, username, password)
You are not supplying a username and password, and it needs one.

tuf-web_co_uk

usng that method is for connecting through php,
i am trying to connect through the mysql app

tsinka

Hi,

if you use the mysql app then you also have to add the correct credentials, e.g.

mysql -uuser -ppassword

tuf-web_co_uk

what are the default settings for these credentials?!

tsinka

Hi,

with a newly installed mysql user is root with password nothing.

mysql -uroot would then be sufficient.

If you compiled MySQL yourself you must also execute mysql_install_db to initialize the mysql database. But you shouldn't use that command if MySQL has already been set up because you would overwrite stuff otherwise.

tuf-web_co_uk

still isnt working 🙁

right in msdos firstly i type what you have said

mysql -uroot

at that point my dos screen then looks like this

mysql > mysql -uroot
>

expecting another command, i then type \c to clear the buffer
then i type

GRANT ALL PRIVILEGES ON . TO "user"@"%" IDENTIFIED BY "password" WITH
GRANT OPTION;

then my dos screen looks like this

mysql> GRANT ALL PRIVILEGES ON . TO "comms"@"%" IDENTIFIED BY "jmplllmi" WITH
GRANT OPTION;
ERROR 1045: Access denied for user: '@' (Using password: NO)

i dont know what i'm doing wrong if anything,

please can you assist me further?!

thanks very much Jon

tsinka

Hi,

it might be a localhost/ip problem.

Try the following:

insert

a) 127.0.0.1 localhost into your windows\hosts file (system32\drivers\etc\hosts on NT/2K/XP).
b) try the following commands:

mysql -uroot -h localhost
mysql -uroot -h 127.0.0.1
mysql -uroot -h <real ip address>
mysql -uroot -h <hostname>

We once had the problem that we couldnt connect to mysql with localhost but with the real hostname. Afterwards we added some records to the mysql.user table for localhost and after that we also were able to connect with -h localhost or with just mysql -uroot.

tuf-web_co_uk

hey again

my hosts file has already got the line

127.0.0.1 localhost

within it

and when i tried the commands you gave me

mysql -uroot 127.0.0.1
etc

i still got the access message

sdjensen

Try
mysql -u root -p

You will then be prompted for the password for root

tuf-web_co_uk

but root doesnt have a password

how can i set it 1?!

pinoy

on command prompt

mysqladmin -hlocalhost -uroot -p password newpassword

tuf-web_co_uk

stupid thing

ok so i open up command prompt

i get the message

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 30 to server version: 4.0.13-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

then i type in

mysqladmin -hlocalhost -uroot -p password <pass here>

if thats right :S

i also tried

mysqladmin -hlocalhost -uroot -p <pass here>
mysqladmin -hlocalhost -uroot -p <pass here> newpassword
mysqladmin -hlocalhost -uroot -p<pass here>
mysqladmin -hlocalhost -uroot -p<pass here> newpassword

and i editted my phpmyadmin config.inc to work with my password and it said

Access denied for user: 'root@127.0.0.1' (Using password: YES)

i dont know why this isnt work!

please could you send give me the exact code for adding a password to the default root user with the password as
thepass

thanks alot

Jon 🙁

sdjensen

you should not open the mysql prompt.

open a command prompt by typing

cmd

in start->run.
when the cmd-prompt opens
type

mysqladmin -hlocalhost -uroot -p password newpassword

tuf-web_co_uk

when i enter

mysqladmin -hlocalhost -uroot -p password something

where "something" is the new password that i want

in the run command (start > run)

i am asked to open the the file "mysqladmin" with a program

although have not much experience with mysql i am sure this isnt meant to happen

instead of using that i then try

c:\webroot\mysql\bin\mysqladmin -hlocalhost -uroot -p password something

where "something" is still the password i want

it then asks me for a password after opening the mysqladmin.exe program i enter the password "something"
my computer bleeps and then mysqladmin.exe closes

before doing this it shows some text but closes before i have time to read it

please can you assist me as this is starting to be irritating, and i'm sure i am following your instructions correctly

Jon

tsinka

Hi,

a different approach:

stop mysql
start the daemon manually skipping the grant tables

mysqld --skip-grant-tables

No connect to mysql with

mysql -h localhost mysql

and do something like

A)
use mysql;
update user set Password = PASSWORD('thepass') where User='root';
flush privileges;

Then quit mysql.

or 😎
mysqladmin -h hostname -u root password 'new password'
mysqladmin -h hostname flush-privileges

You might additionally need to insert a record with % or localhost as Host and root as user and fourteen 'Y' if you want to give root all rights.

INSERT INTO user ('localhost','root',PASSWORD('thepass'),'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y');
FLUSH PRIVILEGES;

(you can do that with mysqladmin either)

Then stop mysql (you might need to kill it manually). Start mysql as usual and try to connect

mysql -h localhost -u root -p

and enter the new root password when asked for it.

tuf-web_co_uk

ah finally the crisis is over

thanks very very much to all the peeps who helped out

now i can do things more safely!!

THANKS AGAIN 😃 🆒

Jon

sdjensen

What kind of windows are you running?

Open a command prompt by typing

command

or

command

then in the command prompt enter

c:\webroot\mysql\bin\mysqladmin -hlocalhost -uroot -p password something

Then you should be able to see the output.

tuf-web_co_uk

i'm running windows xp, but i have the problem solved now

thanks anyway sdjensen