DeNewbie, Monday, September 30, 2002, 9:36:03 PM, you wrote: D> I am a MySQL newbie and i am somewhat confused. Firstly did I make a mistake running mysql_install_db and afterwards running the commands;
D> /usr/bin/mysqladmin -u root password 'new-password' D> mysqladmin -u pazin1 sqlpass D> and; D> /usr/bin/mysqladmin -u root -h cords-orj86jfje password 'new-password' D> mysqladmin -u pazin1 -h hostpass D> After inputting these passwords as I was told by mysql_install_db was this absolutely necessary or did I make my life more difficult as a newbie. Anyway after doing that I followed more D> instructions from p.115 of my MySQL Reference manual written by Mr.Widenius. From your advice I was able to get some results for the mysqlshow command; I don't know where the test database came D> from I did not see it from the result in my Reference Manual; Database 'test' is created by default. If you don't need the one, you can drop it. [skip] D> then when I enter what one person told me to enter I get this; D> cords-orj86jfje:/usr/bin # mysqlshow -u pazin1 -p sqlpass D> Enter password: D> mysqlshow: Access denied for user: 'pazin1@localhost' (Using password: YES) D> cords-orj86jfje:/usr/bin # D> (regardless of what password I entered I was continously kicked out) But you didn't set up password for user 'pazin1'. D> mysqladmin -u pazin1 sqlpass The above isn't correct for setting up password. D> I would also like use the mysqladmin version command to see what pops up but I simply get no results no matter what I type in; D> cords-orj86jfje:/usr/bin # mysqladmin version D> cords-orj86jfje:/usr/bin # mysqladmin version -u hostpass D> cords-orj86jfje:/usr/bin # mysqladmin version -u pazin1 D> cords-orj86jfje:/usr/bin # mysqladmin version -u sqlpass D> cords-orj86jfje:/usr/bin # mysqladmin version -u pazin1 -p sqlpass "no results" means that you didn't get any errors, any output etc, right? D> I would also like to know how to shut down the mysql server,how do i do this, it does not seem to want to shut down; D> cords-orj86jfje:/usr/bin # mysqladmin -u pazin1 shutdown D> cords-orj86jfje:/usr/bin # safe_mysqld & D> [1] 1404 D> cords-orj86jfje:/usr/bin # A mysqld process already exists As I understand you didn't create user 'pazin1'. By default MySQL gives permissions to user 'root' and anonymous user. Anonymous user means that any user can connect to the MySQL server, but it has permissions only on the database 'test' and doesn't have permissions to shutdown MySQL server. So, MySQL still is running. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [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