Still have MySQL problems that need to get solved soon (was: Re: Apache and MySQL won't start)

[Scott Haneda]

On Jul 28, 2010, at 6:46 PM, Ali A Samii wrote:

> However, I still cannot change the password.
> 
> I get the following Error:
> 
> alis-imac:bin ali$ /opt/local/lib/mysql5/bin/mysqladmin -u root password 'golijoon'
> /opt/local/lib/mysql5/bin/mysqladmin: connect to server at 'localhost' failed
> error: 'Can't connect to local MySQL server through socket '/opt/local/var/run/mysql5/mysqld.sock' (2)'
> Check that mysqld is running and that the socket: '/opt/local/var/run/mysql5/mysqld.sock' exists!
> 
> I really need to get this issue solved as soon as possible, so I hope that I can get it done in theft hour or two.

Have you tried:
sudo /opt/local/lib/mysql5/bin/mysql_secure_installation
This will run you through an interactive shell that should get things in order.
 * Probably will not work if Mysql is not loading because it can't locate the socket file.

What is in /opt/local/etc/mysql5/my.cnf for the socket?  
If you have no file in that location, you can find a sample by using:
    $port contents mysql5 | grep \.ini

Once you find the sample configi ini file, you can copy in perhaps the medium one.

I have the values:
    socket		= /opt/local/var/run/mysql5/mysqld.sock

I also added this right after the thread_concurrency = x setting

# Custom settings made by scott at newgeo.com 03/16/2010 05:36:10 PM	

# Without this, OS X will default to 2, HFS is not case-sensitive
# but, http://dev.mysql.com/doc/refman/4.1/en/server-system-variables.html#sysvar_lower_case_table_names
# explicitly states to set to 1 if InnoDB will be used, and I may someday.  It does not seem
# a bad idea to have names forced lowercase, it is consistent
lower_case_table_names=1

# End custom settings made by scott at newgeo.com

if that does not work, and only because you are in a time crunch, as I really don't want to put this file out there, and should instead work to add it to the wiki...

I wrote up a mini tutorial, which I reference when I do new installs, and it tends to get me through it.  There are some errors, obvious ones, where I forgot to sudo or other syntactical issues.

    http://dl.dropbox.com/u/340087/drops/01.04.10/mamp/MAMP%20Tutorial.html

I will yank those files in a day or so as to not pollute the documentation of MacPorts.

MySql should not take more than 5 minutes to get going once it is built.  Depending on how things go tonight, if you really get stuck, drop me an email following the instructions in my sig and I may take you up on your offer to ssh in, which I believe you mentioned in your first post.
-- 
Scott (* For off-list contact, replace talklists@ with scott@ *)