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