Hello Douglas,<div><br></div><div> 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.</div>
<div><br></div><div> 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 :</div><div><br></div><div> mysql -u root -p mysql</div>
<div><br></div><div> 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.</div>
<div><br></div><div> Hope this helps,</div><div><br></div><div>--</div><div>Martyn Ranyard<br><br><div class="gmail_quote">On Fri, Aug 28, 2009 at 5:14 PM, Douglas G Mckendrick <span dir="ltr"><<a href="mailto:douglasg.mckendrick@googlemail.com">douglasg.mckendrick@googlemail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">Thanks for your reply. Yes you are right, I got mysql_install_db to<br>
work. I'm running ubuntu 9.04 and installed mysql with synaptic. I<br>
believe it's v5.01. But if I try and start mysqld with sudo I get the<br>
following error:<br>
<br>
laptop:~$ mysqld<br>
090828 17:00:46 [Warning] Can't create test<br>
<div class="im">file /var/lib/mysql/bones-laptop.lower-test<br>
</div>090828 17:00:46 [Warning] Can't create test<br>
<div class="im">file /var/lib/mysql/bones-laptop.lower-test<br>
</div>090828 17:00:46 [Warning] One can only use the --user switch if running<br>
as root<br>
<br>
090828 17:00:46 InnoDB: Operating system error number 13 in a file<br>
operation.<br>
InnoDB: The error means mysqld does not have the access rights to<br>
InnoDB: the directory.<br>
InnoDB: File name ./ibdata1<br>
InnoDB: File operation call: 'open'.<br>
InnoDB: Cannot continue operation.<br>
<br>
If I try it with /usr/sbin/mysqld --skip-grant &<br>
<br>
<br>
I get: -laptop:~$ sudo /usr/sbin/mysqld --skip-grant &<br>
[1] 4478<br>
-laptop:~$ InnoDB: Unable to lock ./ibdata1, error: 11<br>
InnoDB: Check that you do not already have another mysqld process<br>
InnoDB: using the same InnoDB data or log files.<br>
090828 17:09:03 InnoDB: Retrying to lock the first data file<br>
InnoDB: Unable to lock ./ibdata1, error: 11<br>
InnoDB: Check that you do not already have another mysqld process<br>
InnoDB: using the same InnoDB data or log files.<br>
InnoDB: Unable to lock ./ibdata1, error: 11<br>
InnoDB: Check that you do not already have another mysqld process<br>
InnoDB: using the same InnoDB data or log files.<br>
InnoDB: Unable to lock ./ibdata1, error: 11<br>
InnoDB: Check that you do not already have another mysqld process<br>
InnoDB: using the same InnoDB data or log files.<br>
InnoDB: Unable to lock ./ibdata1, error: 11<br>
InnoDB: Check that you do not already have another mysqld process<br>
InnoDB: using the same InnoDB data or log files.<br>
InnoDB: Unable to lock ./ibdata1, error: 11<br>
InnoDB: Check that you do not already have another mysqld process<br>
InnoDB: using the same InnoDB data or log files.<br>
InnoDB: Unable to lock ./ibdata1, error: 11<br>
<div><div></div><div class="h5"><br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
_______________________________________________<br>
Wylug-help mailing list<br>
<a href="mailto:Wylug-help@wylug.org.uk">Wylug-help@wylug.org.uk</a><br>
<a href="https://mailman.lug.org.uk/mailman/listinfo/wylug-help" target="_blank">https://mailman.lug.org.uk/mailman/listinfo/wylug-help</a><br>
</div></div></blockquote></div><br></div>