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]
