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

[Ali A Samii]

Hi Scott:

Since I couldn't get things to work for me last night (I'm in Paris, France) and I had been up to almost 6 AM to get things to work, I gave up for the night (or I should say the morning) and went to get some sleep.

Anyway, I just got your email with the tutorial, and I am going to do a fresh, clean and directed reinstall of everything according to your tutorial, and I'll get back to you in the event of a hiccup and/or in the event of success.

If all else fails, log into my system. I'll get you the info needed at that time.

Thanks,

Ali

On 29 Jul, 2010, at 06:45 , Scott Haneda wrote:

> 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@ *)
>