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 
i    n    v    e    n    t                                   
---------------------------------------------------------------
 

________________________________

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
        i    n    v    e    n    t
        ---------------------------------------------------------------
        
        -----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!
        
        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
        > i    n    v    e    n    t
        >
---------------------------------------------------------------
        >
        > -----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
        >
        
        
        
        --
        Daniel McQuay
        [EMAIL PROTECTED] 
        boxster.homelinux.org
        814.825.0847
        




-- 
Daniel McQuay
[EMAIL PROTECTED]
boxster.homelinux.org
814.825.0847 

Reply via email to