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
