[ubuntu-us-nm] MySQL server

[David Einerson]

Here's what should be returned by "sudo netstat -tap | grep mysql" if mysql
is up and running:

tcp        0      0 localhost:mysql         *:*
> LISTEN      30807/mysqld
>

On Fri, May 4, 2012 at 9:25 AM, David Einerson <deinerson1 at gmail.com> wrote:

> Good morning,
>
> The command "sudo netstat -tap | grep mysql" will not return anything if
> it doesn't find mysql running.
>
> It will help to send me a couple of files:
> /etc/mysql/my.cnf
> /var/log/mysql/error.log
>
> Hopefully the error log will give us some clues.
>
> I'm not sure what to make of the sudo issue and don't want to jump to
> conclusions. Normally, on ubuntu, there is an admin user that is setup when
> the OS is installed. The actual username is arbitrary. Ubuntu doesn't setup
> a "root" user to be used directly, but only through sudo, so you'll want to
> login as the admin username that was setup when you installed Ubuntu. (And
> keep in mind the OS root user is different from the mysql root user.) We'll
> use the mysql root user for testing once we are sure mysql is up and
> running properly.
>
> Let's take a look at the error.log. That should steer us true.
>
> Diagnosis via email leaves a lot of room for rabbit holes and admittedly,
> sometimes those are the daily routine of diagnosing any system. If you have
> the patience and time, we can figure this out.
>
>
>
> On Thu, May 3, 2012 at 10:31 PM, Researcher Taylor <
> research at lawlearners.org> wrote:
>
>>  Unfortunately, the server guide link you gave must be to an old page
>> because I get several errors and unexpected results.  With this command:
>>
>>         sudo netstat -tap | grep mysql
>>
>> I get nothing... just the command prompt again.  Then the page says I
>> might have to restart mysql with this command:
>>
>>         sudo /etc/init.d/mysql restart
>>
>> I get this error:
>>
>>         Rather than invoking init scripts through /etc/init.d, use the
>> service(8)
>> utility, e.g. service mysql restart
>>
>> Since the script you are attempting to invoke has been converted to an
>> Upstart job, you may also use the restart(8) utility, e.g. restart mysql
>> mysql start/running
>>
>>
>> I have lots of suggestions from people but I don't think that actually
>> try what they suggest to see if it works.  Seems like everyone is leading
>> me down rabbit trails and dead ends.  Is this part of the culture?  I'd
>> like to know before I waste anymore time.
>>
>>
>>
>>
>> On 05/03/2012 02:26 PM, David Einerson wrote:
>>
>> Okay, well, let's rectify that :)
>>
>> I just carefully re-read you email and I should ask a few clarifying
>> questions - my apologies if they are answered in the 1st email and I am
>> simply not clear.
>>
>>
>>    1. Is the mysql instance on a local machine or a remote one from
>>    where you are attempting to connect? mysql, by default disables all
>>    connectivity except on the machine where it is installed, which means that
>>    if I ssh into a server with mysql installed, it considers me local and I
>>    can run commands all day long, but if I run a mysql client of any sort on a
>>    different (remote) machine, it will not connect (not sure of the exact
>>    error it gives). The solution to this issue is in adding the IP
>>    address in my.conf. Here's a good reference:
>>    https://help.ubuntu.com/11.04/serverguide/mysql.html
>>    2. How did you install mysql? Via LAMP or another more targeted
>>    install?
>>
>>
>>
>>
>> --
>> ubuntu-us-nm mailing list
>> ubuntu-us-nm at lists.ubuntu.com
>> https://lists.ubuntu.com/mailman/listinfo/ubuntu-us-nm
>>
>>
>
>
> --
> Dave Einerson
> 505-750-1878
>
>


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