The permissions should be as follows:
/usr/local/mysql/data/ mysql owner 600 is no problem
if the linux.err does not exist create one
touch linux.err
now u can try. I hope it helps.
--
Aftab Jahan Subedar
Software Engineer
Subedar Technologies
Subedar Baag
Bibir Bagicha #1
81/1-A North Jatrbari
Dhaka 1204
Bangladesh
sms://+447765341890
sms://+880171859159
http://www.ceobangladesh.com
http://www.DhakaStockExchangeGame.com
http://www.geocities.com/jahan.geo
/
Peter Bradley wrote:
Hi again Mike,
thanks for your help, but no luck there either. the permissions are 755
with mysql as owner and daemon as group
cheers
Peter
On Wed, 2003-07-30 at 18:52, O'K Web Design wrote:
Hi Peter
It might not be the /tmp directory. This is taken from your original
post.
I did check to see if mysqld was running, but of course it wasn't. I
also tried the perl script run-all-tests, but it just reported mysql
wasn't running ('Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)' when connecting to
DBI:mysql:database=test;host=test;host=localhost with user: '' password:
'')
You might want to check the permissions on the /var/lib/mysql directory as
well. Mike
----- Original Message -----
From: "Peter Bradley" <[EMAIL PROTECTED]>
To: "O'K Web Design" <[EMAIL PROTECTED]>
Sent: July 30, 2003 1:03 AM
Subject: Re: Running mysql (complete newbie)
Hi Mike,
Hmmm. Don't think so. /tmp is drwxrwxrwt
Cheers
Peter
On Wed, 2003-07-30 at 18:43, O'K Web Design wrote:
Hi Peter
It sounds like you have a directory permission problem. I had one
just
this week. Just make sure that mysql can write to /tmp. Mike
----- Original Message -----
From: "Peter Bradley" <[EMAIL PROTECTED]>
To: "msql general mailing list" <[EMAIL PROTECTED]>
Sent: July 30, 2003 12:50 AM
Subject: Running mysql (complete newbie)
Hi guys and gals,
I'm a complete newbie to mysql, so please bear with me.
Today I downloaded mysql4.0 binary distribution and installed it on my
SuSE Linux 8.1 box. I've unzipped it and put it in:
/usr/local/mysql-standard-4.0.14-pc-linux-i686
and I've created a symbolic link to give me /usr/local/mysql
I then ran scripts/mysql_install_db (as root). The output was:
=====================================================================
|
|linux:/usr/local/mysql # ./scripts/mysql_install_db
|Installing all prepared tables
|030730 4:24:13 ./bin/mysqld: Shutdown Complete
|
|
|To start mysqld at boot time you have to copy
|support-files/mysql.server
|to the right place for your system
|
|PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
|This is done with:
|./bin/mysqladmin -u root password 'new-password'
|./bin/mysqladmin -u root -h linux password 'new-password'
|See the manual for more instructions.
|
|NOTE: If you are upgrading from a MySQL <= 3.22.10 you should run
|the ./bin/mysql_fix_privilege_tables. Otherwise you will not be
|able to use the new GRANT command!
|
|You can start the MySQL daemon with:
|cd . ; ./bin/mysqld_safe &
|
|You can test the MySQL daemon with the benchmarks in the 'sql-bench'
|directory:
|cd sql-bench ; perl run-all-tests
|
|Please report any problems with the ./bin/mysqlbug script!
|
|The latest information about MySQL is available on the web at
|http://www.mysql.com
|Support MySQL by buying support/licenses at https://order.mysql.com
|
|linux:/usr/local/mysql #
|
===================================================================
I then tried to start mysql as a normal user and got:
====================================================================
|
|[EMAIL PROTECTED]:/usr/local/mysql> bin/safe_mysqld --log &
|[1] 2693
|[EMAIL PROTECTED]:/usr/local/mysql> Starting mysqld daemon with databases
|from /usr/local/mysql/data
|bin/safe_mysqld: line 296: /usr/local/mysql/data/linux.err:
Permission
|denied
|rm: cannot remove `/tmp/mysql.sock': Operation not permitted
|bin/safe_mysqld: line 1: /usr/local/mysql/data/linux.err: Permission
|denied
|tee: /usr/local/mysql/data/linux.err: Permission denied
|030730 04:27:40 mysqld ended
|tee: /usr/local/mysql/data/linux.err: Permission denied
|
|==================================================================
So I tried as root and got:
====================================================================
|
|linux:/usr/local/mysql # ./bin/safe_mysqld --log &
|[1] 2740
|linux:/usr/local/mysql # Starting mysqld daemon with databases from
|/usr/local/mysql/data
|030730 04:30:05 mysqld ended
|
====================================================================
I did check to see if mysqld was running, but of course it wasn't. I
also tried the perl script run-all-tests, but it just reported mysql
wasn't running ('Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2)' when connecting to
DBI:mysql:database=test;host=test;host=localhost with user: ''
password:
'')
Can anyone help?
Thanks
Peter
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
