Aggro wrote:
ra**********@gmail.com wrote:
I want to download sql in my linux system...........
Unless you absolutely need some specific version that can't be found
from the package system of your Linux distribution, for that question,
you get best help from the support forums of your Linux distribution.
For example on Ubuntu, installing MySQL requires this:
sudo apt-get update
sudo apt-get install mysql-server
You can of course do that from GUI also, by searching the mysql server
package and marking it for installation. For other distributions, there
should be as simple methods for them too.
[root@localhost mydb]# mysqladmin -u root password 'sait123'
Try this and it should ask you for the password:
mysqladmin -u root -p
It is not recommended to enter the password directly to the commandline,
as it is visible to other users.
hi,
i tried your command. the result is seem's like below .........
[root@localhost mydb]# mysqladmin -u root -p
mysqladmin Ver 8.41 Distrib 5.0.24a, for pc-linux-gnu on i686
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Administration program for the mysqld daemon.
Usage: mysqladmin [OPTIONS] command command....
-c, --count=# Number of iterations to make. This works with -i
(--sleep) only.
-#, --debug[=name] Output debug log. Often this is 'd:t:o,filename'.
-f, --force Don't ask for confirmation on drop database; with
multiple commands, continue even if an error
occurs.
-C, --compress Use compression in server/client protocol.
--character-sets-dir=name
Directory where character sets are.
--default-character-set=name
Set the default character set.
-?, --help Display this help and exit.
-h, --host=name Connect to host.
-p, --password[=name]
Password to use when connecting to server. If
password is
not given it's asked from the tty.
................
....................
......................
I had following commands also. i got error
[root@localhost mydb]# mysql -uroot -psait123
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: YES)
[root@localhost mydb]# mysqladmin -u root password 'sait123'
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
tankyou
-raju