[Wylug-help] mysql installation.

[Martyn Ranyard]

Hello Douglas,
  If you've installed mysql-server with synaptic (dpkg -l mysql-server will
tell you) you'll probably want to use ubuntu's startup rather than
attempting to run mysqld yourself.  The command "/etc/init.d/mysql start"
(without quotes) is what you would be expected to start mysql with, however,
I would expect it has already been started.  I would hazard a guess that
you're following a guide that is not tailored to ubuntu.

  If you have the mysql client (I would expect so if you have the server)
installed, you can type the following to verify that the sql server is
running :

  mysql -u root -p mysql

  I happen to know that the installation package for ubuntu is based on the
debian package and should have asked you to create a password for root
(which is not necessarily the same as your normal root password, but you may
have assumed it was), and that command will ask you for this.  If you didn't
get a prompt, you may find the password hidden in /etc/mysql somewhere.

  Hope this helps,

--
Martyn Ranyard

On Fri, Aug 28, 2009 at 5:14 PM, Douglas G Mckendrick <
douglasg.mckendrick at googlemail.com> wrote:

> Thanks for your reply.  Yes you are right, I got mysql_install_db to
> work.  I'm running ubuntu 9.04 and installed mysql with synaptic.  I
> believe it's v5.01.  But if I try and start mysqld with sudo I get the
> following error:
>
> laptop:~$ mysqld
> 090828 17:00:46 [Warning] Can't create test
> file /var/lib/mysql/bones-laptop.lower-test
> 090828 17:00:46 [Warning] Can't create test
> file /var/lib/mysql/bones-laptop.lower-test
> 090828 17:00:46 [Warning] One can only use the --user switch if running
> as root
>
> 090828 17:00:46  InnoDB: Operating system error number 13 in a file
> operation.
> InnoDB: The error means mysqld does not have the access rights to
> InnoDB: the directory.
> InnoDB: File name ./ibdata1
> InnoDB: File operation call: 'open'.
> InnoDB: Cannot continue operation.
>
> If I try it with /usr/sbin/mysqld --skip-grant &
>
>
> I get:  -laptop:~$ sudo /usr/sbin/mysqld --skip-grant &
> [1] 4478
> -laptop:~$ InnoDB: Unable to lock ./ibdata1, error: 11
> InnoDB: Check that you do not already have another mysqld process
> InnoDB: using the same InnoDB data or log files.
> 090828 17:09:03  InnoDB: Retrying to lock the first data file
> InnoDB: Unable to lock ./ibdata1, error: 11
> InnoDB: Check that you do not already have another mysqld process
> InnoDB: using the same InnoDB data or log files.
> InnoDB: Unable to lock ./ibdata1, error: 11
> InnoDB: Check that you do not already have another mysqld process
> InnoDB: using the same InnoDB data or log files.
> InnoDB: Unable to lock ./ibdata1, error: 11
> InnoDB: Check that you do not already have another mysqld process
> InnoDB: using the same InnoDB data or log files.
> InnoDB: Unable to lock ./ibdata1, error: 11
> InnoDB: Check that you do not already have another mysqld process
> InnoDB: using the same InnoDB data or log files.
> InnoDB: Unable to lock ./ibdata1, error: 11
> InnoDB: Check that you do not already have another mysqld process
> InnoDB: using the same InnoDB data or log files.
> InnoDB: Unable to lock ./ibdata1, error: 11
>
>
>
>
>
>
>
>
>
>
>
> _______________________________________________
> Wylug-help mailing list
> Wylug-help at wylug.org.uk
> https://mailman.lug.org.uk/mailman/listinfo/wylug-help
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.lug.org.uk/pipermail/wylug-help/attachments/20090828/a3805daf/attachment.htm