|
|
What Is Mysql's Default Root Password? - Just installed in on my Linux box | ||
Discussion by michaelper22 with 11 Replies.
Last Update: January 2, 2010, 9:41 pm ( View Rated (10) ) | |||
![]() |
|
|
Also, an a different note, why would the system stop loading after a certain point (towards the end, don't remeber where) if I have my USB drive plugged in before booting?
QUOTE
After a fresh installation, you should connect to the server and set up your users and their access permissions:shell> mysql -u root mysql
The server should let you connect because the MySQL root user has no password initially. That is also a security risk, so setting the password for the root accounts is something you should do while you're setting up your other MySQL users. For instructions on setting the initial passwords, see Section 2.9.3, “Securing the Initial MySQL Accounts”.
The manuals are available at mysql.com either for online reading or by downloading. If you have installed it locally, probably best to download it.
Hope this helps.
http://dev.mysql.com/doc/refman/5.0/en/password-hashing.html
http://www.experts-exchange.com/Databases/...Q_20678779.html
You can set the root password by typing this:
CODE
# mysqladmin -u root password 'new-password'You can then login by typing this:
CODE
# mysql -u root –pThen you'll be prompted to provide the password you specified earlier.
You also might want to delete the anonymous user in the User's table. The default configuration of MySQL allows any user access to the system without
providing a username or password.
Delete the user by typing this:
CODE
# mysql -u root –pmysql> use mysql
mysql> delete from user where User='';
mysql> quit
mysqladmin -you root password foo
When I run:
mysql -you root �p and enter foo when prompted, I get:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
Ideas?
What Is Mysql's Default Root Password?
Hi,I have installed easy php1.8 on to my system and I created a database and tables in it.I'm trying to send the form data written in html to my database using php code.I'm getting errors like
Access denied for user@localhost using password (yes)
Here I didnt used any username or password or it was not asked during installation.So,because of the above error I'm unable to connect to the database.Hence I'm unable to send the form data tomy database table.I dontknow whether there may be any default passwords or not.
Please help me out
What Is Mysql's Default Root Password?
Replying to Trap FeedBacker
Even I just installed my mysql. It dint prompt for any password when it was installed nor did the blank password work. It returs with the same error when I try to open sql or try to change the password... Any help?
-reply by Rajaram
CODE
/etc/init.d/mysql stopRun
CODE
mysqld_safe --skip-grant-tables &Enter as root
CODE
mysql -u root -pTo change root password
CODE
mysql client - mysql -u rootand write
CODE
use mysqlupdate user set password=PASSWORD(”NEW-ROOT-PASSWORD”) where User=’root’;
What Is Mysql's Default Root Password?
Replying to Framp
Dude I've been searching for an answer ALL DAY LONG! Thank you so much this helped tons!
-reply by Drew
To log in as the root user, type mysql -u root -p and for the password, just press Enter.
Hi everybody,I have recently transferred from shared hosting to virtual private server.And when moving my database to a newserver (VPS) I was unable to Login to Mysql or PhpMyAdmin.Iam using Login: root (which is unix SSH login)Pass: password for ( Unix SSH access)Can anyone tell me how to login to mysql or phpmyadminOr where the configuration file will be?Waiting for replies
Saiful
-reply by Saiful
Similar Topics:
Installing Joomla On Local Computer...
Default settings for mysql
Set Path For Mysql Which Is Install...
What Is Flash? (12)
|
(16) Connect To Remote Oracle Database With Toad i'm lost
|
Loading...
HOME 





WAMP 2.2 (Bundled) Part 1 - Install Tutorial & Set MySQL root password in phpMyAdmin
Tutorial: How to install MySQL on Linux (Fedora 13)
Team Speak 3 Beta - MYSQL Server Admin Password FIX
Linux Mint - Install Apache Mysql PHP phpMyAdmin (LAMPP)

