-
July 10th, 2002, 07:47 PM
#1
MySQL Help
Does anyone know the command to set the password for the root user (new install) and start the server?
-
July 10th, 2002, 08:05 PM
#2
Junior Member
Hi ac1dsp3ctrum,
Which version of MySQL are you using? Windows or Linux?
If you're using for windows you can set the root/administrator password after installation by going to the directory / folder where you have installed MySQL.
Proceed to the bin folder and double-click winmysqladmin.exe it will ask you for the username and password of the administrator, and it will automatically load MySQL afterwards.
Hope this helps.
-
July 10th, 2002, 08:12 PM
#3
the only thing that doesn\'t change is everything will always change.
-
July 10th, 2002, 08:13 PM
#4
http://www.codebits.com/bit.cfm?BitID=120
http://www.mysql.com/doc/D/e/Default_privileges.html gives you....
shell> mysql -u root mysql
mysql> SET PASSWORD FOR root@localhost=PASSWORD('new_password');
Hope something there helps....
\"Ignorance is bliss....
but only for your enemy\"
-- souleman
-
July 10th, 2002, 08:18 PM
#5
from install :
You should also add a password for the `root' user. The following
example starts by removing the anonymous user that can be used by anyone
to access the `test' database, then sets a `root' user password:
C:\> C:\mysql\bin\mysql mysql
mysql> DELETE FROM user WHERE Host='localhost' AND User='';
mysql> QUIT
C:\> C:\mysql\bin\mysqladmin reload
C:\> C:\mysql\bin\mysqladmin -u root password your_password
After you've set the password, if you want to take down the `mysqld'
server, you can do so using this command:
C:\> mysqladmin --user=root --password=your_password shutdown
* Use passwords for all MySQL users. Remember that anyone can log in
as any other person as simply as `mysql -u other_user db_name' if
`other_user' has no password. It is common behavior with
client/server applications that the client may specify any user
name. You can change the password of all users by editing the
`mysql_install_db' script before you run it, or only the password
for the MySQL `root' user like this:
shell> mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD('new_password')
WHERE user='root';
mysql> FLUSH PRIVILEGES;
Because your installation is initially wide open, one of the first
things you should do is specify a password for the MySQL `root' user.
You can do this as follows (note that you specify the password using
the `PASSWORD()' function):
shell> mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD('new_password')
WHERE user='root';
mysql> FLUSH PRIVILEGES;
Neb
There is only one constant, one universal, it is the only real truth: causality. Action. Reaction. Cause and effect...There is no escape from it, we are forever slaves to it. Our only hope, our only peace is to understand it, to understand the 'why'. 'Why' is what separates us from them, you from me. 'Why' is the only real social power, without it you are powerless.
(Merovingian - Matrix Reloaded)
-
July 10th, 2002, 08:32 PM
#6
Attached is Install file (compressed)
There is only one constant, one universal, it is the only real truth: causality. Action. Reaction. Cause and effect...There is no escape from it, we are forever slaves to it. Our only hope, our only peace is to understand it, to understand the 'why'. 'Why' is what separates us from them, you from me. 'Why' is the only real social power, without it you are powerless.
(Merovingian - Matrix Reloaded)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|