re: User Specific Instance Running
Anthony, Friday, October 11, 2002, 5:26:39 AM, you wrote: AWM There is non-root user implementation of MySQL-Pro 4.0.4 linux binary in AWM this users environment (RH 7.3). AWM my.cnf has been modified to include individual user, port , AWM bind-address and host specifics (and etc) unique to that user and is AWM passed as --defaults-file through mysqld_safe script. Data AWM directories are already available with this user/group's ownership. AWM All attempts to run mysql -u root file and other privledged commands This is not a privilege command :-) It means that you connect as user 'root' without a password to the database 'file'. AWM (also tried --skip-grant-tables) end up with Error 1045 Access Denied AWM ? --skip-grant-tables is an option of mysqld, not a mysql client program. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: User Specific Instance Running
Victoria Reznichenko wrote: Anthony, Friday, October 11, 2002, 5:26:39 AM, you wrote: AWM There is non-root user implementation of MySQL-Pro 4.0.4 linux binary in AWM this users environment (RH 7.3). AWM my.cnf has been modified to include individual user, port , AWM bind-address and host specifics (and etc) unique to that user and is AWM passed as --defaults-file through mysqld_safe script. Data AWM directories are already available with this user/group's ownership. AWM All attempts to run mysql -u root file and other privledged commands This is not a privilege command :-) It means that you connect as user 'root' without a password to the database 'file'. This occurs immediately after running mysql_install_db then running mysql.server scripts so there isn't any passwords at this time. AWM (also tried --skip-grant-tables) end up with Error 1045 Access Denied AWM ? --skip-grant-tables is an option of mysqld, not a mysql client program. Understood, however, doesn't using that switch (with mysqld) impact how you gain access to the server from a security aspect whether using mysql, mysqladmin etc? Thank You, Anthon - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php