answersLogoWhite

0


Best Answer

In order for the MySQL server to be secure, it must have a unique and non-guessable password. Thus we cannot give you a password, as that would mean someone could access the database without your permission. A good password should be at least six characters long and consist of both alphabetical and numerical characters. It should be easy for you to remember but not something that could be found through a simple dictionary attack.

User Avatar

Wiki User

14y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What should be the root password for MySQL server?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

How do you create a MySQL database on the server?

Here is how you establish connection to mysql server & create a database in mysql <?php // Note that username, client host & passwords may vary $host = "localhost"; $user = "root"; $password = ""; $con = mysql_connect($host,$user,$password); if(!$con) { // Warns for connection failure die("Failure in establishing connection: ".mysql_error()); } $db = "CREATE DATABASE employees"; // Use any name for database $create = mysql_query($db, $con); if(!$create) { echo "Error creating database: ".mysql_error(); } ?>


Locations of root domain server in India?

In inda there is a root server in Chennai. It is the Root server for total Asia..


How do you install Joomla in Ubuntu?

1. first Install LAMP (Linux, Apache, MySQL, PHP)Install LAMP on UbuntuThe Ubuntu developers have made it easy to install the LAMP server packages with a single command. Simply open a terminal window and enter the following. sudo apt-get install lamp-server^No, that's not a typo. Please make sure to include the caret (^). The command will not work without it.sudo apt-get install lamp-server^The apt package manager will show all the packages that need to be installed. Hit to confirm that you want to install them.LAMP packagesYou will then be prompted to change the password for the root user on the MySQL database.Set MySQL root passwordEnter the password you want. You'll be prompted to enter it a second time to confirm.After you confirm your password, apt will continue to install the rest of the packages.Congratulations, your LAMP installation is now complete! That was the easy part, now you need to get a few things configured to make your system easy to work with.Test ApacheOpen a web browser and enter the address http://localhost/. You should see a web page that says "It Works!"Testing ApacheTest phpNow that you know Apache works, you'll want to test the phpinstallation. You'll need to create a file in /var/wwwcalled testing.php. Open a terminal and enter:sudo nano /var/www/testing.php Enter the following line into the text editor, save the file and exit.Next, restart Apache with the following terminal command:sudo /etc/init.d/apache2 restartNow go back to your web browser and enter the address http://localhost/testing.php/. You should see a page displaying version information for your php installation.php InformationConfigure MySQLSince I'm installing LAMP for a web development environment, I want the MySQL database to be bound to the localhost IP address. This should be 127.0.0.1 for your system. You can verify it with this terminal command.cat /etc/hosts | grep localhost You'll now want to verify that the correct bind address is set up in MySQL's my.cnf file.cat /etc/mysql/my.cnf | grep bind-addressYou should see a line that looks like this: bind-address = 127.0.0.1If the IP address doesn't match the one for your system, you'll need to edit the my.cnf file to correct it.Install phpMyAdminYou don't need to install phpMyAdmin, but it's a much easier way to get in and adjust things in your MySQL database if you're not familiar with MySQL's commands. You can install phpMyAdmin from the command line with:sudo apt-get install libapache2-mod-auth-mysql phpmyadmin The installation will prompt you to select a web server for automatic configuration.phpMyAdmin SetupThis is important! Use the space bar on your keyboard to select apache2. Make sure there's a * next to apache2 like the picture below and then hit . (Click the picture to enlarge it and see what I'm talking about.)phpMyAdmin Setup: select apache2The next screen will explain some information about database configuration. Hit the key to move on.phpMyAdmin database configAnother screen will come up asking if you want to configure a new database called dbconfig-common. Since this is a fresh installation, use the key to select Yes and hit .phpMyAdmin dbconfig-commonYou'll be prompted next to enter the MySQL root password. Enter the MySQL root password that you created earlier, hit to select Ok and hit .MySQL root passwordYou'll then be prompted to enter a MySQL application password for phpmyadmin. You can hit and a random password will be generated. I chose to use the same password that I used for the root MySQL password.MySQL application passwordIf you enter your own password, a password confirmation screen will come up. Confirm your password.MySQL application password confirmationYour phpMyAdmin installation and configuration is now complete.Testing phpMyAdminOpen your web browser and enter the address http://localhost/phpmyadmin/. You should see a page like this. phpMyAdmin log inYou can log in with the username root and the root password that you created earlier.Logged into phpMyAdminCongratulations, you're now ready to start building your local website. If you're only working on one site you can put all of your files into /var/www. If you'll be working on multiple sites you may want to consider some additional Apache configuration to keep things neat and clean on you system.2. Then download joomla from joomla dowload page (www.joomla.org)extract your joomla zip file in /var/www/ and then locate your browser to your extract joomla file Follow the joomla instruction instruction.That is it....


What is the password for su root in Linux?

The password would be whatever the root password is set to.


How do you connect mysql database with php program?

You can do that using the mysql_connect() function. For example: <?php $host='localhost'; //Your Host Name Here $username='root'; //MySQL Username $pass='';//MySQL Password $dbname='codenair'; //your Database Name //Connecting Database mysql_connect($host,$username,$pass)or die('Failed to Connect'); //Selecting Database mysql_select_db($dbname)or die('Database Not Found'); echo 'Connected'; ?>


What parameter and value is used to allow ssh logins as root to the openssh server as long as the user enters the password?

Before I answer, a warning: This is a highly dangerous setting that is not recommended. This allows direct access to the root account of a remote machine, making it especially vulnerable to SSH server exploits. It is *much* better to install and use sudo with a regular user, especially through SSH. Crackers will be looking for root accounts, not normal users as their names are hard to predict. Finding an SSH server that happily allows a root login is precisely what evildoers are hoping for. Now, to answer your question: To log in as root: "PermitRootLogin yes" in /etc/etc/sshd_config... As long as there's no keypair associated with root on either machine it should require a password. But do yourself a favor and install sudo instead.


What is the correct way to connect to a MySQL database?

Simple way to connect to mysql server using PHP..


You want secure the password of root user?

Your question isn't exactly clear. If you want to secure the password, give root a secure password.


Where is the root password stored in Ubuntu?

The root password is stored in hashed form in the /etc/shadow file.


How do you sign on in root on Mac OS X?

If you do not know how to do this you probably should not do this. You can seriously mess things up if you do not know what you are doing. Most users would never have a need to sign in as the Root User as most tasks can be performed with the sudo (substituteuser do) command. The process to sign in as Root varies in different editions of Mac OS X for 10.6 and up...Open the Accounts section and unlock the lock in the bottom left corner with your admin password. Click on Login Options and then click Join Network Account Server. Open the Directory Utility. Unlock with your admin password. Choose Enable Root User from Directory Utility's Edit menu. Enter a Root password.


What could cause the Forwarders and Root Hints to be grayed out?

Win2K configured your DNS server as a private root server


What is a root password?

In Linux and Unix-like systems, the "root" account is the only account with all possible privileges. The "root" password would be the password needed to access this account or assume its identity.