Re: i'm at a complete loss?
On Sun, 28 May 2006 20:17:53 -0400 Daniel McQuay [EMAIL PROTECTED] wrote: Hello list, I just installed MySQL on my FreeBSD box here at home and am having a few problems with privileges. I can connect to mysql using; mysql -u mysql and there is no password needed. However, when I try to connect to the server using root; mysql -u root I get an error; snip ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) /snip so reading that it appears that I need a password so i try; mysql -u root -p it prompts me for my root pass and when I put it in it does that same thing above but with (using password: YES). I went to the the MySQL web site and read 2.10.3 Securing the Initial MySQL Accounts and tried following along with that but with no luck. When checking google for help I read a lot about the initial installation. Something about /usr/local/bin/mysql_install_db will install a privilege table. I installed mysql using this guide here http://raybdbomb.com/p/mysql-install-on-freebsd.html and every thing seemed to go well but like I said I keep getting this error. Is there something else I should do? Any help on this would be MUCH appreciated. Hi, Wasn't clear to me in reading your post that you did this so here goes: Did you actually set a root password for mysql using a GRANT statement after logging in with the default BLANK password? mysql -u root -p [then just hit enter] HTH, G -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: i'm at a complete loss?
Thanks Greg, I did try that here is what happened. boxster# mysql -u root -p Enter password: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) boxster# So I really just don't know what to do from here. I'm up for any ideas if any one has 'em. On 5/29/06, Greg Maruszeczka [EMAIL PROTECTED] wrote: On Sun, 28 May 2006 20:17:53 -0400 Daniel McQuay [EMAIL PROTECTED] wrote: Hello list, I just installed MySQL on my FreeBSD box here at home and am having a few problems with privileges. I can connect to mysql using; mysql -u mysql and there is no password needed. However, when I try to connect to the server using root; mysql -u root I get an error; snip ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) /snip so reading that it appears that I need a password so i try; mysql -u root -p it prompts me for my root pass and when I put it in it does that same thing above but with (using password: YES). I went to the the MySQL web site and read 2.10.3 Securing the Initial MySQL Accounts and tried following along with that but with no luck. When checking google for help I read a lot about the initial installation. Something about /usr/local/bin/mysql_install_db will install a privilege table. I installed mysql using this guide here http://raybdbomb.com/p/mysql-install-on-freebsd.html and every thing seemed to go well but like I said I keep getting this error. Is there something else I should do? Any help on this would be MUCH appreciated. Hi, Wasn't clear to me in reading your post that you did this so here goes: Did you actually set a root password for mysql using a GRANT statement after logging in with the default BLANK password? mysql -u root -p [then just hit enter] HTH, G -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Daniel McQuay [EMAIL PROTECTED] boxster.homelinux.org 814.825.0847
Re: i'm at a complete loss?
Log into the server, and type, use mysql; without the quotes.
Look at the user table - that defines what user can connect to the database, the ip addresses they can use, and the password
they must provide.
For example, you could enter,
INSERT INTO USER (host, user, password)
values ('127.0.0.1', 'mysql', password(mysql));
and
INSERT INTO USER (host, user, password)
values ('localhost', 'mysql', password(mysql));
Don't forget to do a flush privileges; afterwards (again, no quotes);
The mysql schema is thoroughly (but dryly) documented @ http://dev.mysql.com
David
Daniel McQuay wrote:
Thanks Greg, I did try that here is what happened.
boxster# mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: NO)
boxster#
So I really just don't know what to do from here. I'm up for any ideas
if
any one has 'em.
On 5/29/06, Greg Maruszeczka [EMAIL PROTECTED] wrote:
On Sun, 28 May 2006 20:17:53 -0400
Daniel McQuay [EMAIL PROTECTED] wrote:
Hello list,
I just installed MySQL on my FreeBSD box here at home and am having
a
few problems with privileges. I can connect to mysql using; mysql -u
mysql and there is no password needed. However, when I try to
connect
to the server using root; mysql -u root I get an error;
snip
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: NO)
/snip
so reading that it appears that I need a password so i try; mysql -u
root -p it prompts me for my root pass and when I put it in it does
that same thing above but with (using password: YES).
I went to the the MySQL web site and read 2.10.3 Securing the
Initial
MySQL Accounts and tried following along with that but with no luck.
When checking google for help I read a lot about the initial
installation. Something about /usr/local/bin/mysql_install_db will
install a privilege table.
I installed mysql using this guide here
http://raybdbomb.com/p/mysql-install-on-freebsd.html and every thing
seemed to go well but like I said I keep getting this error. Is
there
something else I should do? Any help on this would be MUCH
appreciated.
Hi,
Wasn't clear to me in reading your post that you did this so here
goes:
Did you actually set a root password for mysql using a GRANT
statement after logging in with the default BLANK password?
mysql -u root -p [then just hit enter]
HTH,
G
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: i'm at a complete loss?
When I log in using mysql which by the way is the only user that I can log
into with I get
snip
mysql USE mysql;
ERROR 1044 (42000): Access denied for user ''@'localhost' to database
'mysql'
/snip
I have to log in to using mysql -u mysql and it drops me into the mysql
command line. It seems as though the user mysql has absolutely no
privileges to do any thing and I cant log in as root. So I have no idea what
I did wrong but this is the third time I installed MySQL41 and I don't think
reinstalling would do any thing different.
Thanks go out to every one for trying to help me, but like I said I have no
idea as to whats wrong.
On 5/29/06, David Griffiths [EMAIL PROTECTED] wrote:
Log into the server, and type, use mysql; without the quotes.
Look at the user table - that defines what user can connect to the
database, the ip addresses they can use, and the password
they must provide.
For example, you could enter,
INSERT INTO USER (host, user, password)
values ('127.0.0.1', 'mysql', password(mysql));
and
INSERT INTO USER (host, user, password)
values ('localhost', 'mysql', password(mysql));
Don't forget to do a flush privileges; afterwards (again, no quotes);
The mysql schema is thoroughly (but dryly) documented @
http://dev.mysql.com
David
Daniel McQuay wrote:
Thanks Greg, I did try that here is what happened.
boxster# mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: NO)
boxster#
So I really just don't know what to do from here. I'm up for any ideas
if
any one has 'em.
On 5/29/06, Greg Maruszeczka [EMAIL PROTECTED] wrote:
On Sun, 28 May 2006 20:17:53 -0400
Daniel McQuay [EMAIL PROTECTED] wrote:
Hello list,
I just installed MySQL on my FreeBSD box here at home and am having
a
few problems with privileges. I can connect to mysql using; mysql -u
mysql and there is no password needed. However, when I try to
connect
to the server using root; mysql -u root I get an error;
snip
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: NO)
/snip
so reading that it appears that I need a password so i try; mysql -u
root -p it prompts me for my root pass and when I put it in it does
that same thing above but with (using password: YES).
I went to the the MySQL web site and read 2.10.3 Securing the
Initial
MySQL Accounts and tried following along with that but with no luck.
When checking google for help I read a lot about the initial
installation. Something about /usr/local/bin/mysql_install_db will
install a privilege table.
I installed mysql using this guide here
http://raybdbomb.com/p/mysql-install-on-freebsd.html and every thing
seemed to go well but like I said I keep getting this error. Is
there
something else I should do? Any help on this would be MUCH
appreciated.
Hi,
Wasn't clear to me in reading your post that you did this so here
goes:
Did you actually set a root password for mysql using a GRANT
statement after logging in with the default BLANK password?
mysql -u root -p [then just hit enter]
HTH,
G
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
Daniel McQuay
[EMAIL PROTECTED]
boxster.homelinux.org
814.825.0847
RE: i'm at a complete loss?
Hi Daniel,
Sounds like there are a few records missing out of the mysql tables. Did
you run mysql_install_db?
http://dev.mysql.com/doc/refman/4.1/en/unix-post-installation.html
Regards
---
** _/ ** David Logan
*** _/ *** ITO Delivery Specialist - Database
*_/* Hewlett-Packard Australia Ltd
_/_/_/ _/_/_/ E-Mail: [EMAIL PROTECTED]
_/ _/ _/ _/ Desk: +618 8408 4273
_/ _/ _/_/_/ Mobile: 0417 268 665
*_/ **
** _/ Postal: 148 Frome Street,
_/ ** Adelaide SA 5001
Australia
invent
---
-Original Message-
From: Daniel McQuay [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 30 May 2006 9:53 AM
To: David Griffiths
Cc: mysql@lists.mysql.com
Subject: Re: i'm at a complete loss?
When I log in using mysql which by the way is the only user that I can
log
into with I get
snip
mysql USE mysql;
ERROR 1044 (42000): Access denied for user ''@'localhost' to database
'mysql'
/snip
I have to log in to using mysql -u mysql and it drops me into the mysql
command line. It seems as though the user mysql has absolutely no
privileges to do any thing and I cant log in as root. So I have no idea
what
I did wrong but this is the third time I installed MySQL41 and I don't
think
reinstalling would do any thing different.
Thanks go out to every one for trying to help me, but like I said I have
no
idea as to whats wrong.
On 5/29/06, David Griffiths [EMAIL PROTECTED] wrote:
Log into the server, and type, use mysql; without the quotes.
Look at the user table - that defines what user can connect to the
database, the ip addresses they can use, and the password
they must provide.
For example, you could enter,
INSERT INTO USER (host, user, password)
values ('127.0.0.1', 'mysql', password(mysql));
and
INSERT INTO USER (host, user, password)
values ('localhost', 'mysql', password(mysql));
Don't forget to do a flush privileges; afterwards (again, no
quotes);
The mysql schema is thoroughly (but dryly) documented @
http://dev.mysql.com
David
Daniel McQuay wrote:
Thanks Greg, I did try that here is what happened.
boxster# mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: NO)
boxster#
So I really just don't know what to do from here. I'm up for any
ideas
if
any one has 'em.
On 5/29/06, Greg Maruszeczka [EMAIL PROTECTED] wrote:
On Sun, 28 May 2006 20:17:53 -0400
Daniel McQuay [EMAIL PROTECTED] wrote:
Hello list,
I just installed MySQL on my FreeBSD box here at home and am
having
a
few problems with privileges. I can connect to mysql using; mysql
-u
mysql and there is no password needed. However, when I try to
connect
to the server using root; mysql -u root I get an error;
snip
ERROR 1045 (28000): Access denied for user 'root'@'localhost'
(using
password: NO)
/snip
so reading that it appears that I need a password so i try; mysql
-u
root -p it prompts me for my root pass and when I put it in it
does
that same thing above but with (using password: YES).
I went to the the MySQL web site and read 2.10.3 Securing the
Initial
MySQL Accounts and tried following along with that but with no
luck.
When checking google for help I read a lot about the initial
installation. Something about /usr/local/bin/mysql_install_db
will
install a privilege table.
I installed mysql using this guide here
http://raybdbomb.com/p/mysql-install-on-freebsd.html and every
thing
seemed to go well but like I said I keep getting this error. Is
there
something else I should do? Any help on this would be MUCH
appreciated.
Hi,
Wasn't clear to me in reading your post that you did this so here
goes:
Did you actually set a root password for mysql using a GRANT
statement after logging in with the default BLANK password?
mysql -u root -p [then just hit enter]
HTH,
G
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
Daniel McQuay
[EMAIL PROTECTED]
boxster.homelinux.org
814.825.0847
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: i'm at a complete loss?
Yeah when I ran it the first time I get this message:
snip
boxster# /usr/local/bin/mysql_install_db --user=mysql
Installing all prepared tables
Fill help tables
To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/local/bin/mysqladmin -u root password 'new-password'
/usr/local/bin/mysqladmin -u root -h boxster.mydomain.com password
'new-password'
See the manual for more instructions.
NOTE: If you are upgrading from a MySQL = 3.22.10 you should run
the /usr/local/bin/mysql_fix_privilege_tables. Otherwise you will not be
able to use the new GRANT command!
You can start the MySQL daemon with:
cd /usr/local ; /usr/local/bin/mysqld_safe
You can test the MySQL daemon with the benchmarks in the 'sql-bench'
directory:
cd sql-bench ; perl run-all-tests
Please report any problems with the /usr/local/bin/mysqlbug script!
The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at https://order.mysql.com
boxster#
/snip
I then follow the directions on setting a password for root but I get
basically the same error message.
snip
boxster# /usr/local/bin/mysqladmin -u root password ''
/usr/local/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
boxster#
/snip
Even though I get an error message I tried running cd /usr/local ;
/usr/local/bin/mysqld_safe but I then get this error:
snip
boxster# cd /usr/local ; /usr/local/bin/mysqld_safe
[1] 33209
boxster# Starting mysqld daemon with databases from /usr/local/var
STOPPING server from pid file /usr/local/var/boxster.mydomain.com.pid
060529 20:45:47 mysqld ended
[1]Done ( cd /usr/local;
/usr/local/bin/mysqld_safe )
boxster#
/snip
I went to that directory and read the error log and it says I have an
instance of mysqld running, which I do. ps auxw | grep myslqd show it there
running.
Thanks again!
On 5/29/06, Logan, David (SST - Adelaide) [EMAIL PROTECTED] wrote:
Hi Daniel,
Sounds like there are a few records missing out of the mysql tables. Did
you run mysql_install_db?
http://dev.mysql.com/doc/refman/4.1/en/unix-post-installation.html
Regards
---
** _/ ** David Logan
*** _/ *** ITO Delivery Specialist - Database
*_/* Hewlett-Packard Australia Ltd
_/_/_/ _/_/_/ E-Mail: [EMAIL PROTECTED]
_/ _/ _/ _/ Desk: +618 8408 4273
_/ _/ _/_/_/ Mobile: 0417 268 665
*_/ **
** _/ Postal: 148 Frome Street,
_/ ** Adelaide SA 5001
Australia
invent
---
-Original Message-
From: Daniel McQuay [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 30 May 2006 9:53 AM
To: David Griffiths
Cc: mysql@lists.mysql.com
Subject: Re: i'm at a complete loss?
When I log in using mysql which by the way is the only user that I can
log
into with I get
snip
mysql USE mysql;
ERROR 1044 (42000): Access denied for user ''@'localhost' to database
'mysql'
/snip
I have to log in to using mysql -u mysql and it drops me into the mysql
command line. It seems as though the user mysql has absolutely no
privileges to do any thing and I cant log in as root. So I have no idea
what
I did wrong but this is the third time I installed MySQL41 and I don't
think
reinstalling would do any thing different.
Thanks go out to every one for trying to help me, but like I said I have
no
idea as to whats wrong.
On 5/29/06, David Griffiths [EMAIL PROTECTED] wrote:
Log into the server, and type, use mysql; without the quotes.
Look at the user table - that defines what user can connect to the
database, the ip addresses they can use, and the password
they must provide.
For example, you could enter,
INSERT INTO USER (host, user, password)
values ('127.0.0.1', 'mysql', password(mysql));
and
INSERT INTO USER (host, user, password)
values ('localhost', 'mysql', password(mysql));
Don't forget to do a flush privileges; afterwards (again, no
quotes);
The mysql schema is thoroughly (but dryly) documented @
http://dev.mysql.com
David
Daniel McQuay wrote:
Thanks Greg, I did try that here is what happened.
boxster# mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: NO)
boxster#
So I really just don't know what to do from here. I'm up for any
ideas
if
any one has 'em.
On 5/29/06, Greg Maruszeczka [EMAIL PROTECTED] wrote:
On Sun, 28 May 2006 20:17:53 -0400
Daniel McQuay [EMAIL PROTECTED] wrote
Re: i'm at a complete loss?
Just for shits and giggles I tried boxster# /usr/local/bin/mysql_install_db
--user=root and then tried logging in as root mysql -u root and now it says
snip
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)
/snip
I googled that and found no resolve to the problem. FYI I had seen that
error before on my machine and tried to solve, but with no luck.
On 5/29/06, Daniel McQuay [EMAIL PROTECTED] wrote:
Yeah when I ran it the first time I get this message:
snip
boxster# /usr/local/bin/mysql_install_db --user=mysql
Installing all prepared tables
Fill help tables
To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/local/bin/mysqladmin -u root password 'new-password'
/usr/local/bin/mysqladmin -u root -h boxster.mydomain.com password
'new-password'
See the manual for more instructions.
NOTE: If you are upgrading from a MySQL = 3.22.10 you should run
the /usr/local/bin/mysql_fix_privilege_tables. Otherwise you will not be
able to use the new GRANT command!
You can start the MySQL daemon with:
cd /usr/local ; /usr/local/bin/mysqld_safe
You can test the MySQL daemon with the benchmarks in the 'sql-bench'
directory:
cd sql-bench ; perl run-all-tests
Please report any problems with the /usr/local/bin/mysqlbug script!
The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at https://order.mysql.com
boxster#
/snip
I then follow the directions on setting a password for root but I get
basically the same error message.
snip
boxster# /usr/local/bin/mysqladmin -u root password ''
/usr/local/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
boxster#
/snip
Even though I get an error message I tried running cd /usr/local ;
/usr/local/bin/mysqld_safe but I then get this error:
snip
boxster# cd /usr/local ; /usr/local/bin/mysqld_safe
[1] 33209
boxster# Starting mysqld daemon with databases from /usr/local/var
STOPPING server from pid file /usr/local/var/boxster.mydomain.com.pid
060529 20:45:47 mysqld ended
[1]Done ( cd /usr/local;
/usr/local/bin/mysqld_safe )
boxster#
/snip
I went to that directory and read the error log and it says I have an
instance of mysqld running, which I do. ps auxw | grep myslqd show it there
running.
Thanks again!
On 5/29/06, Logan, David (SST - Adelaide) [EMAIL PROTECTED] wrote:
Hi Daniel,
Sounds like there are a few records missing out of the mysql tables. Did
you run mysql_install_db?
http://dev.mysql.com/doc/refman/4.1/en/unix-post-installation.html
Regards
---
** _/ ** David Logan
*** _/ *** ITO Delivery Specialist - Database
*_/* Hewlett-Packard Australia Ltd
_/_/_/ _/_/_/ E-Mail: [EMAIL PROTECTED]
_/ _/ _/ _/ Desk: +618 8408 4273
_/ _/ _/_/_/ Mobile: 0417 268 665
*_/ **
** _/ Postal: 148 Frome Street,
_/ ** Adelaide SA 5001
Australia
invent
---
-Original Message-
From: Daniel McQuay [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 30 May 2006 9:53 AM
To: David Griffiths
Cc: mysql@lists.mysql.com
Subject: Re: i'm at a complete loss?
When I log in using mysql which by the way is the only user that I can
log
into with I get
snip
mysql USE mysql;
ERROR 1044 (42000): Access denied for user ''@'localhost' to database
'mysql'
/snip
I have to log in to using mysql -u mysql and it drops me into the mysql
command line. It seems as though the user mysql has absolutely no
privileges to do any thing and I cant log in as root. So I have no idea
what
I did wrong but this is the third time I installed MySQL41 and I don't
think
reinstalling would do any thing different.
Thanks go out to every one for trying to help me, but like I said I have
no
idea as to whats wrong.
On 5/29/06, David Griffiths [EMAIL PROTECTED] wrote:
Log into the server, and type, use mysql; without the quotes.
Look at the user table - that defines what user can connect to the
database, the ip addresses they can use, and the password
they must provide.
For example, you could enter,
INSERT INTO USER (host, user, password)
values ('127.0.0.1', 'mysql', password(mysql));
and
INSERT INTO USER (host, user, password)
values ('localhost', 'mysql', password(mysql));
Don't forget to do a flush privileges; afterwards (again, no
quotes);
The mysql schema is thoroughly
RE: i'm at a complete loss?
Hi Daniel,
Is this actually the instance that you have just installed? I know that
sounds trite but if it is running during the installation maybe it
hasn't been able to start the new server and you are still trying to
connect to the old one.
Kill the server currently running, restart it and try again.
Regards
---
** _/ ** David Logan
*** _/ *** ITO Delivery Specialist - Database
*_/* Hewlett-Packard Australia Ltd
_/_/_/ _/_/_/ E-Mail: [EMAIL PROTECTED]
_/ _/ _/ _/ Desk: +618 8408 4273
_/ _/ _/_/_/ Mobile: 0417 268 665
*_/ **
** _/ Postal: 148 Frome Street,
_/ ** Adelaide SA 5001
Australia
invent
---
-Original Message-
From: Daniel McQuay [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 30 May 2006 10:20 AM
Cc: David Griffiths; mysql@lists.mysql.com
Subject: Re: i'm at a complete loss?
Yeah when I ran it the first time I get this message:
snip
boxster# /usr/local/bin/mysql_install_db --user=mysql
Installing all prepared tables
Fill help tables
To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/local/bin/mysqladmin -u root password 'new-password'
/usr/local/bin/mysqladmin -u root -h boxster.mydomain.com password
'new-password'
See the manual for more instructions.
NOTE: If you are upgrading from a MySQL = 3.22.10 you should run
the /usr/local/bin/mysql_fix_privilege_tables. Otherwise you will not be
able to use the new GRANT command!
You can start the MySQL daemon with:
cd /usr/local ; /usr/local/bin/mysqld_safe
You can test the MySQL daemon with the benchmarks in the 'sql-bench'
directory:
cd sql-bench ; perl run-all-tests
Please report any problems with the /usr/local/bin/mysqlbug script!
The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at https://order.mysql.com
boxster#
/snip
I then follow the directions on setting a password for root but I get
basically the same error message.
snip
boxster# /usr/local/bin/mysqladmin -u root password ''
/usr/local/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
boxster#
/snip
Even though I get an error message I tried running cd /usr/local ;
/usr/local/bin/mysqld_safe but I then get this error:
snip
boxster# cd /usr/local ; /usr/local/bin/mysqld_safe
[1] 33209
boxster# Starting mysqld daemon with databases from /usr/local/var
STOPPING server from pid file /usr/local/var/boxster.mydomain.com.pid
060529 20:45:47 mysqld ended
[1]Done ( cd /usr/local;
/usr/local/bin/mysqld_safe )
boxster#
/snip
I went to that directory and read the error log and it says I have an
instance of mysqld running, which I do. ps auxw | grep myslqd show it
there
running.
Thanks again!
On 5/29/06, Logan, David (SST - Adelaide) [EMAIL PROTECTED] wrote:
Hi Daniel,
Sounds like there are a few records missing out of the mysql tables.
Did
you run mysql_install_db?
http://dev.mysql.com/doc/refman/4.1/en/unix-post-installation.html
Regards
---
** _/ ** David Logan
*** _/ *** ITO Delivery Specialist - Database
*_/* Hewlett-Packard Australia Ltd
_/_/_/ _/_/_/ E-Mail: [EMAIL PROTECTED]
_/ _/ _/ _/ Desk: +618 8408 4273
_/ _/ _/_/_/ Mobile: 0417 268 665
*_/ **
** _/ Postal: 148 Frome Street,
_/ ** Adelaide SA 5001
Australia
invent
---
-Original Message-
From: Daniel McQuay [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 30 May 2006 9:53 AM
To: David Griffiths
Cc: mysql@lists.mysql.com
Subject: Re: i'm at a complete loss?
When I log in using mysql which by the way is the only user that I can
log
into with I get
snip
mysql USE mysql;
ERROR 1044 (42000): Access denied for user ''@'localhost' to database
'mysql'
/snip
I have to log in to using mysql -u mysql and it drops me into the
mysql
command line. It seems as though the user mysql has absolutely no
privileges to do any thing and I cant log in as root. So I have no
idea
what
I did wrong but this is the third time I installed MySQL41 and I don't
Re: i'm at a complete loss?
Nah, that's not the case my friend. I made sure that when I installed mysql
that the old one was completely removed. But, I do think I figured something
out. I was reading the MySQL documentation and it said that if I was having
problems with mysql_install_db that I should move the mysql directory, the
one with all my information, to mysql.old and try the mysql_install_db. I
did that and every thins seemed to go just fine.
Now my problem is with this:
snip
boxster# /usr/local/bin/mysqladmin -u root password 'flNT3b4c'
/usr/local/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock'
(2)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists!
/snip
Have you ever seen that error before? Now I cant connect at all. :(
On 5/29/06, Logan, David (SST - Adelaide) [EMAIL PROTECTED] wrote:
Hi Daniel,
Is this actually the instance that you have just installed? I know that
sounds trite but if it is running during the installation maybe it
hasn't been able to start the new server and you are still trying to
connect to the old one.
Kill the server currently running, restart it and try again.
Regards
---
** _/ ** David Logan
*** _/ *** ITO Delivery Specialist - Database
*_/* Hewlett-Packard Australia Ltd
_/_/_/ _/_/_/ E-Mail: [EMAIL PROTECTED]
_/ _/ _/ _/ Desk: +618 8408 4273
_/ _/ _/_/_/ Mobile: 0417 268 665
*_/ **
** _/ Postal: 148 Frome Street,
_/ ** Adelaide SA 5001
Australia
invent
---
-Original Message-
From: Daniel McQuay [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 30 May 2006 10:20 AM
Cc: David Griffiths; mysql@lists.mysql.com
Subject: Re: i'm at a complete loss?
Yeah when I ran it the first time I get this message:
snip
boxster# /usr/local/bin/mysql_install_db --user=mysql
Installing all prepared tables
Fill help tables
To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/local/bin/mysqladmin -u root password 'new-password'
/usr/local/bin/mysqladmin -u root -h boxster.mydomain.com password
'new-password'
See the manual for more instructions.
NOTE: If you are upgrading from a MySQL = 3.22.10 you should run
the /usr/local/bin/mysql_fix_privilege_tables. Otherwise you will not be
able to use the new GRANT command!
You can start the MySQL daemon with:
cd /usr/local ; /usr/local/bin/mysqld_safe
You can test the MySQL daemon with the benchmarks in the 'sql-bench'
directory:
cd sql-bench ; perl run-all-tests
Please report any problems with the /usr/local/bin/mysqlbug script!
The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at https://order.mysql.com
boxster#
/snip
I then follow the directions on setting a password for root but I get
basically the same error message.
snip
boxster# /usr/local/bin/mysqladmin -u root password ''
/usr/local/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
boxster#
/snip
Even though I get an error message I tried running cd /usr/local ;
/usr/local/bin/mysqld_safe but I then get this error:
snip
boxster# cd /usr/local ; /usr/local/bin/mysqld_safe
[1] 33209
boxster# Starting mysqld daemon with databases from /usr/local/var
STOPPING server from pid file /usr/local/var/boxster.mydomain.com.pid
060529 20:45:47 mysqld ended
[1]Done ( cd /usr/local;
/usr/local/bin/mysqld_safe )
boxster#
/snip
I went to that directory and read the error log and it says I have an
instance of mysqld running, which I do. ps auxw | grep myslqd show it
there
running.
Thanks again!
On 5/29/06, Logan, David (SST - Adelaide) [EMAIL PROTECTED] wrote:
Hi Daniel,
Sounds like there are a few records missing out of the mysql tables.
Did
you run mysql_install_db?
http://dev.mysql.com/doc/refman/4.1/en/unix-post-installation.html
Regards
---
** _/ ** David Logan
*** _/ *** ITO Delivery Specialist - Database
*_/* Hewlett-Packard Australia Ltd
_/_/_/ _/_/_/ E-Mail: [EMAIL PROTECTED]
_/ _/ _/ _/ Desk: +618 8408 4273
_/ _/ _/_/_/ Mobile: 0417 268 665
*_/ **
** _/ Postal: 148 Frome Street
RE: i'm at a complete loss?
Ah, this is a little different. I know there are a couple of OS's (redhat AFAIK) that place the mysql socket in a different location http://dev.mysql.com/doc/refman/4.1/en/problems-with-mysql-sock.html Your socket has probably been placed in a spot where the server is not expecting it. You may need to update the my.cnf files to reflect the correct location or add a --socket option to the server when it starts. Regards --- ** _/ ** David Logan *** _/ *** ITO Delivery Specialist - Database *_/* Hewlett-Packard Australia Ltd _/_/_/ _/_/_/ E-Mail: [EMAIL PROTECTED] _/ _/ _/ _/ Desk: +618 8408 4273 _/ _/ _/_/_/ Mobile: 0417 268 665 *_/ ** ** _/ Postal: 148 Frome Street, _/ ** Adelaide SA 5001 Australia invent --- From: Daniel McQuay [mailto:[EMAIL PROTECTED] Sent: Tuesday, 30 May 2006 10:39 AM To: Logan, David (SST - Adelaide) Cc: David Griffiths; mysql@lists.mysql.com Subject: Re: i'm at a complete loss? Nah, that's not the case my friend. I made sure that when I installed mysql that the old one was completely removed. But, I do think I figured something out. I was reading the MySQL documentation and it said that if I was having problems with mysql_install_db that I should move the mysql directory, the one with all my information, to mysql.old and try the mysql_install_db. I did that and every thins seemed to go just fine. Now my problem is with this: snip boxster# /usr/local/bin/mysqladmin -u root password 'flNT3b4c' /usr/local/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)' Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! /snip Have you ever seen that error before? Now I cant connect at all. :( On 5/29/06, Logan, David (SST - Adelaide) [EMAIL PROTECTED] wrote: Hi Daniel, Is this actually the instance that you have just installed? I know that sounds trite but if it is running during the installation maybe it hasn't been able to start the new server and you are still trying to connect to the old one. Kill the server currently running, restart it and try again. Regards --- ** _/ ** David Logan *** _/ *** ITO Delivery Specialist - Database *_/* Hewlett-Packard Australia Ltd _/_/_/ _/_/_/ E-Mail: [EMAIL PROTECTED] _/ _/ _/ _/ Desk: +618 8408 4273 _/ _/ _/_/_/ Mobile: 0417 268 665 *_/ ** ** _/ Postal: 148 Frome Street, _/ ** Adelaide SA 5001 Australia invent --- -Original Message- From: Daniel McQuay [mailto: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ] Sent: Tuesday, 30 May 2006 10:20 AM Cc: David Griffiths; mysql@lists.mysql.com Subject: Re: i'm at a complete loss? Yeah when I ran it the first time I get this message: snip boxster# /usr/local/bin/mysql_install_db --user=mysql Installing all prepared tables Fill help tables To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! To do so, start the server, then issue the following commands: /usr/local/bin/mysqladmin -u root password 'new-password' /usr/local/bin/mysqladmin -u root -h boxster.mydomain.com password 'new-password' See the manual for more instructions. NOTE: If you are upgrading from a MySQL = 3.22.10 you should run the /usr/local/bin/mysql_fix_privilege_tables. Otherwise you will not be able to use the new GRANT command! You can start the MySQL daemon with: cd /usr/local ; /usr/local/bin/mysqld_safe You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory: cd sql-bench ; perl run-all-tests Please report any problems with the /usr/local/bin/mysqlbug script
Re: i'm at a complete loss?
Well, good news! after renaming the mysql to mysql.old and running
mysql_install_db --user=mysql and then restarting the machine I am now able
to run mysql as root by typing mysql -u root -p and just hitting enter when
prompted for a password.
Now I guess I just got to set the password (currently reading about how to
do that) and I good from there.
Thanks for all your help guys.
On 5/29/06, Logan, David (SST - Adelaide) [EMAIL PROTECTED] wrote:
Ah, this is a little different. I know there are a couple of OS's (redhat
AFAIK) that place the mysql socket in a different location
http://dev.mysql.com/doc/refman/4.1/en/problems-with-mysql-sock.html
Your socket has probably been placed in a spot where the server is not
expecting it. You may need to update the my.cnf files to reflect the
correct location or add a --socket option to the server when it starts.
Regards
---
** _/ ** David Logan
*** _/ *** ITO Delivery Specialist – Database
*_/* Hewlett-Packard Australia Ltd
_/_/_/ _/_/_/ E-Mail: [EMAIL PROTECTED]
_/ _/ _/ _/ Desk: +618 8408 4273
_/ _/ _/_/_/ Mobile: 0417 268 665
*_/ **
** _/ Postal: 148 Frome Street,
_/ ** Adelaide SA 5001
Australia
invent
---
--
*From:* Daniel McQuay [mailto:[EMAIL PROTECTED]
*Sent:* Tuesday, 30 May 2006 10:39 AM
*To:* Logan, David (SST - Adelaide)
*Cc:* David Griffiths; mysql@lists.mysql.com
*Subject:* Re: i'm at a complete loss?
Nah, that's not the case my friend. I made sure that when I installed
mysql that the old one was completely removed. But, I do think I figured
something out. I was reading the MySQL documentation and it said that if I
was having problems with mysql_install_db that I should move the mysql
directory, the one with all my information, to mysql.old and try the
mysql_install_db. I did that and every thins seemed to go just fine.
Now my problem is with this:
snip
boxster# /usr/local/bin/mysqladmin -u root password 'flNT3b4c'
/usr/local/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)'
Check that mysqld is running and that the socket: '/tmp/mysql.sock'
exists!
/snip
Have you ever seen that error before? Now I cant connect at all. :(
On 5/29/06, Logan, David (SST - Adelaide) [EMAIL PROTECTED] wrote:
Hi Daniel,
Is this actually the instance that you have just installed? I know that
sounds trite but if it is running during the installation maybe it
hasn't been able to start the new server and you are still trying to
connect to the old one.
Kill the server currently running, restart it and try again.
Regards
---
** _/ ** David Logan
*** _/ *** ITO Delivery Specialist - Database
*_/* Hewlett-Packard Australia Ltd
_/_/_/ _/_/_/ E-Mail: [EMAIL PROTECTED]
_/ _/ _/ _/ Desk: +618 8408 4273
_/ _/ _/_/_/ Mobile: 0417 268 665
*_/ **
** _/ Postal: 148 Frome Street,
_/ ** Adelaide SA 5001
Australia
invent
---
-Original Message-
From: Daniel McQuay [mailto: [EMAIL PROTECTED]
Sent: Tuesday, 30 May 2006 10:20 AM
Cc: David Griffiths; mysql@lists.mysql.com
Subject: Re: i'm at a complete loss?
Yeah when I ran it the first time I get this message:
snip
boxster# /usr/local/bin/mysql_install_db --user=mysql
Installing all prepared tables
Fill help tables
To start mysqld at boot time you have to copy support-files/mysql.server
to the right place for your system
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/local/bin/mysqladmin -u root password 'new-password'
/usr/local/bin/mysqladmin -u root -h boxster.mydomain.com password
'new-password'
See the manual for more instructions.
NOTE: If you are upgrading from a MySQL = 3.22.10 you should run
the /usr/local/bin/mysql_fix_privilege_tables. Otherwise you will not be
able to use the new GRANT command!
You can start the MySQL daemon with:
cd /usr/local ; /usr/local/bin/mysqld_safe
You can test the MySQL daemon with the benchmarks in the 'sql-bench'
directory:
cd sql-bench ; perl run-all-tests
Please report any problems with the /usr/local/bin/mysqlbug script!
The latest information about MySQL is available on the web
i'm at a complete loss?
Hello list, I just installed MySQL on my FreeBSD box here at home and am having a few problems with privileges. I can connect to mysql using; mysql -u mysql and there is no password needed. However, when I try to connect to the server using root; mysql -u root I get an error; snip ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) /snip so reading that it appears that I need a password so i try; mysql -u root -p it prompts me for my root pass and when I put it in it does that same thing above but with (using password: YES). I went to the the MySQL web site and read 2.10.3 Securing the Initial MySQL Accounts and tried following along with that but with no luck. When checking google for help I read a lot about the initial installation. Something about /usr/local/bin/mysql_install_db will install a privilege table. I installed mysql using this guide here http://raybdbomb.com/p/mysql-install-on-freebsd.html and every thing seemed to go well but like I said I keep getting this error. Is there something else I should do? Any help on this would be MUCH appreciated. Thanks in advance, -- Daniel McQuay [EMAIL PROTECTED] boxster.homelinux.org 814.825.0847
