No you don't. Mysql will run perfectly happily as a standard user. If you're installing from an rpm you will however need root privilege unless the rpm is configured as relocatable - and the standard mysql ones aren't.
What you need to do is get yourself the source tarball (.gz) and not the rpm. Install it locally, and build it. You'll need to set --prefix=<local path to which you have access> and if port 3306 is blocked you'll need to set --tcp-port=<port> Run the build and install as standard from this point which will install mysql into you're local directory. Configure you're data dir and run the install_db script. I suggest you copy one of the /share/<dbsize>.cnf files To a my.cnf in the data dir and edit it appropriately and use --defaults-file=<data dir>/my.cnf as a parameter to the install_db script. Then set your path so it picks up <install_dir>/bin and run nohup mysqld_safe & to start the mysqld as you. The rest of the admin/user configuration is standard. Kevin Cowley R&D Tel: 0118 902 9099 (direct line) Email: [EMAIL PROTECTED] Web: http://www.alchemetrics.co.uk -----Original Message----- From: B. Fongo [mailto:[EMAIL PROTECTED] Sent: 29 April 2004 11:45 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Mysql. Com Subject: FW: Help with a basic question I can't seem to find an answer. You will need root privilege in order to install and start MySQL. After the installation, you may have to edit some confs to get MySQL to start automatically at every boot. Thereafter, you can access the database server be creating a user account for Mysql admin (root), plus unlimited number of user accounts. See MySQL Docs for more about the installation: http://dev.mysql.com/doc/mysql/en/Installing.html HTH Babs ||> -----Original Message----- ||> From: Sreekanth Nagisetty [mailto:[EMAIL PROTECTED] ||> Sent: Wednesday, April 28, 2004 10:32 PM ||> To: [EMAIL PROTECTED] ||> Subject: Help with a basic question I can't seem to find an answer. ||> ||> Here is a basic question I am struggling to find an answer. I want to run ||> mysql under solaris. Security is not a great concern to me and only one ||> application accesses the database locally. I don't have and can't get the ||> root access to the machine. Also, I can't create mysql user and groups on ||> this machine. Can someone tell me if it is possible for me to install and ||> run mysql completely as a normal user on the system? If it is, can you ||> please give me a rough idea on how to proceed with the installation? I ||> searched the mysql mailing lists and rest of the internest pretty ||> extensively ( I think!!) and stil couldn't find a straight answer. Thank you ||> very much for your time and help. ||> ||> _________________________________________________________________ ||> Stop worrying about overloading your inbox - get MSN Hotmail Extra Storage! ||> http://join.msn.com/?pgmarket=en-us&page=hotmail/es2&ST=1/go/onm00200362 ave/direct/01/ ||> ||> ||> -- ||> 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] ************************************************************************************** ALCHEMETRICS LIMITED (ALCHEMETRICS) Mulberry Park, Fishponds Road, Wokingham, Berkshire, RG41 2GX Tel: +44 (0) 118 902 9000 Fax: +44 (0) 118 902 9001 This e-mail is confidential and is intended for the use of the addressee only. If you are not the intended recipient, you are hereby notified that you must not use, copy, disclose, otherwise disseminate or take any action based on this e-mail or any information herein. If you receive this transmission in error, please notify the sender immediately by reply e-mail or by using the contact details above and then delete this e-mail. Please note that e-mail may be susceptible to data corruption, interception and unauthorised amendment. Alchemetrics does not accept any liability for any such corruption, interception, amendment or the consequences thereof. ************************************************************************************** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]