[ubuntu-us-nm] MySQL server

[David Einerson]

Hey there, have you gotten any assistance with this, yet? I may be able to
help.

On Tue, May 1, 2012 at 10:55 PM, Researcher Taylor <research at lawlearners.org
> wrote:

> I am attempting to set up a database in MySQL. The instructions for Drupal
> 7 say use this command:
>
>    mysqladmin -u username -p create databasename
>
> But all I get is this:
>
>    connect to server at 'localhost' failed
>    error: 'Can't connect to local MySQL server through socket
> '/var/run/mysqld/mysqld.sock' (2)'
>
>
> I searched on many web sites.  Every one gives different solutions.  I'm
> pulling my hair out trying to figure out why the command doesn't not work.
>
> The solutions say that either mysql isn't running or my user does not have
> the right permission.  I tried this to see if mysqld was running:
>
>    ls -ld /var/lib/mysql.sock
>
> And got this:
>
>    ls: cannot access /var/lib/mysql.sock: No such file or directory
>
> And this:
>
>    service mysql start
>
> Got this:
>
>    start: Job is already running: mysql
>
> Then it said to make sure your user was a member of mysql group.  Did that
> with:
>
>        usermod -G mysql USE_YOUR_NAME_HERE
>
> Then manually change permissions for the directory with this:
>
>       chmod g+rwx /var/lib/mysql
>
> I get this:
>
>        drwxrwx--- 4 mysql mysql 4096 2012-05-01 22:41 /var/lib/mysql
>
> Then I tried the original command again:
>
>    mysqladmin -u username -p create databasename
>
> And get this:
>
>    mysqladmin: connect to server at 'localhost' failed
> error: 'Can't connect to local MySQL server through socket
> '/var/run/mysqld/mysqld.sock' (2)'
> Check that mysqld is running and that the socket:
> '/var/run/mysqld/mysqld.sock' exists!
>
> I tried a blank password and the one for my user.  I was in a terminal
> window as root (root at user-desktop).
>
> I'm lost now!  Need help.
>
> Thanks!
>
>
>
>
>
> --
> ubuntu-us-nm mailing list
> ubuntu-us-nm at lists.ubuntu.com
> https://lists.ubuntu.com/**mailman/listinfo/ubuntu-us-nm<https://lists.ubuntu.com/mailman/listinfo/ubuntu-us-nm>
>



-- 
Dave Einerson
505-750-1878
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.ubuntu.com/archives/ubuntu-us-nm/attachments/20120503/a618e57f/attachment.html>