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 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] > 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
-- Daniel McQuay [EMAIL PROTECTED] boxster.homelinux.org 814.825.0847