Actually I'm not manually starting mysqld it starts on boot. I'm talking about when I try and run the mysql.<br><br><div><span class="gmail_quote">On 5/28/06, <b class="gmail_sendername">Bill Moran</b> <<a href="mailto:wmoran@potentialtech.com">
wmoran@potentialtech.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">"Daniel McQuay" <<a href="mailto:simplebob@gmail.com">
simplebob@gmail.com</a>> wrote:<br><br>> Hello list,<br>><br>> I'm not exactly sure if this a question for this list or MySQL but here goes<br>> it.<br>><br>> I just installed the mysql from ports using this howto (
<br>> <a href="http://raybdbomb.com/p/mysql-install-on-freebsd.html">http://raybdbomb.com/p/mysql-install-on-freebsd.html</a>) and all seemed to go<br>> well. I then ran /usr/local/bin/mysql_install_db. And then started mysql.
<br>> When I try to start mysql with mysql -u root -p and put my password in I<br>> get: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using<br>> password: YES), but I am able to use mysql -u mysql and get in and mess
<br>> around but with limited privileges.<br>><br>> I checked out the MySQL documentation and it told me to do: mysqladmin -u<br>> root -h <a href="http://boxster.mydomain.com">boxster.mydomain.com</a> password "my_new_password", but after I do that
<br>> the terminal hands and the only way I can break it is with control z. When I<br>> do that though, it opens another process of mysql but now with mysqladmin<br>> running as root, according to top at the shell prompt.
<br>><br>> Oh, and when I run ps auxw |grep mysqld the out put looks like this:<br>><br>> <snip><br>> boxster# ps auxw |grep mysqld<br>> root 769 0.0 0.1 1440 592 p0 R+ 10:31PM 0:00.01
grep mysqld<br>> mysql 473 0.0 0.2 1660 1196 con- I 9:33PM 0:00.07 /bin/sh<br>> /usr/local/bin/mysqld_safe --user=mysql --datadir=/var/db/mys<br>> mysql 520 0.0 4.5 56748 26132 con- S 9:33PM<br>
> 0:13.93/usr/local/libexec/mysqld --basedir=/usr/local<br>> --datadir=/var/db/mysq<br>> boxster#<br>> </snip><br>><br>> I noticed that --datadir= goes to /var/db/mys and /var/db/mysq but there's<br>
> no such directories named mys and mysq. Just in case this was the error I<br>> made both of those directories but I'm suspicious of that.<br><br>Those directories must have the database files in them. You can't just
<br>create them. Looks like you typed in commands wrong.<br><br>The last few steps are incorrect anyway. You shouldn't be manually starting<br>mysqld. Read through /usr/local/etc/rc.d/msyqld.sh (or whatever it's<br>called) and put the correct configuration values in /etc/rc.conf. Then
<br>execute the rc script to start/stop it.<br><br>--<br>Bill Moran<br><br>I lay down for a while, and I woke up on the ocean,<br>floating on my back, and staring at the grey.<br>It was completely still, 'cept for the pounding of my heart,
<br>was bring me back to life, from three strange days.<br><br>_______________________________________________<br>wplug mailing list<br><a href="mailto:wplug@wplug.org">wplug@wplug.org</a><br><a href="http://www.wplug.org/mailman/listinfo/wplug">
http://www.wplug.org/mailman/listinfo/wplug</a><br></blockquote></div><br><br clear="all"><br>-- <br>Daniel McQuay<br><a href="mailto:simplebob@gmail.com">simplebob@gmail.com</a><br><a href="http://boxster.homelinux.org">
boxster.homelinux.org</a><br>814.825.0847