Answers to: Setting up MySQL into the home directory<p>Hi Guys, </p> <p>I am trying to install MySQL into the home directory. I am following these instructions from;p=1</p> <pre><code># First, reserve a port number by going into the WebFaction control panel and creating a new app of type "Custom App listenting on port". MY_PORT=PUT_THE_PORT_NUMBER_HERE mkdir -p ~/mysql/.src ~/mysql/tmp cd ~/mysql/.src/ # Download and extract the Mysql source code: wget tar xf mysql-5.0.51b.tar.gz cd mysql-5.0.51b ./configure --prefix=$HOME/mysql make # Go take a 30-minute break... make install cat &gt; $HOME/mysql/my.cnf &lt;&lt; EOF [mysqld] port=$MY_PORT socket=$HOME/mysql/mysql.sock basedir=$HOME/mysql datadir=$HOME/mysql/data [client] port=$MY_PORT socket=$HOME/mysql/mysql.sock EOF echo export PATH=$HOME/mysql/bin:$PATH &gt;&gt; ~/.bash_profile source ~/.bash_profile mysql_install_db --basedir=$HOME/mysql --datadir=$HOME/mysql/data --tmpdir=$HOME/mysql/tmp # Start the MySQL Server: cd $HOME/mysql; mysqld_safe --defaults-file=$HOME/mysql/my.cnf &amp; # Choose a password for root: mysqladmin -u root -P $MY_PORT -S $HOME/mysql/mysql.sock password "aPasswordForRoot" </code></pre> <p>SQL version trying to install: 5.1.56</p> <p>Problem: When I try to execute the last instruction to choose a password I get this error </p> <pre><code>mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user 'root'@'localhost' (using password: NO)' </code></pre> <p>I have tried every possible solution that I could find on the net but none have worked. I have tried to set the privilages but that failed too. MySQL just wouldn't let me log into the database and change anything.</p> <p>I believe that I missed a instruction somewhere and that's the reason why I am having this problem. So I want to uninstall everything and start again but I don't know how to uninstall mySQL. I have tried to kill the <strong>mysqld</strong> process but that fails too and get message like this this:</p> <pre><code>mysqld(30255): Operation not permitted </code></pre> <p>I'm not sure what to do next. I am new to this and any help would be greatly appretiated :-)</p> <p>Thanks in advance.....</p>enThu, 05 Jan 2012 19:37:41 +0000Answer by ryans<p>If installing a new MySQL instance, please use the instructions as shown here, which are updated and maintained to ensure that they work:</p> <p><a href=""></a></p>ryansThu, 05 Jan 2012 19:37:41 +0000 by johns<p>You should check what mysqladmin you are using to be sure, </p> <p>$ which mysqladmin</p> <p>Is that the binary bundled with your new build or the system one?</p> <p>Are you replacing -P $MY_PORT with the correct port?</p> <p>To uninstall anything you build from source you simply delete the directory it was installed to. </p>johnsSat, 21 May 2011 17:21:54 +0000