Hi everyone, I have read the READMEs the FAQs and the excellent beginners tutorial at www.devshed.com but I cant get MySQL working. when I run mysqld as root it gives 'cant change dir to /var/lib/mysql errcode:2' and that directory doesnt exist. I have installed all the mysql RPMs off the Mandrake 7.0 CD except for some of the developer ones. someone suggested this is because I dont have a database for it to work with, so I did mysqladmin create testdb but that returned connect to server at '' failed; error: 'Cant connect to local mysql server (111)' presumably because the daemon bit wasnt running. any ideas?? thanks!!
