CODEWITHSUNDEEP
mysqlphpmyadmin
Sam
Sam

Reputation: 4284

Setting username and password in phpmyadmin

I need to set the username and password in phpmyadmin for mysql.

I think the default username is root@localhost.

I do not know how to set this.

Upvotes: 4

Views: 40712

Answers (2)

Drewness
Drewness

Reputation: 5072

The 'root' user would have been setup during the initial install. If you open the config.default.php file you will see

$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '********';

This information can be changed provided you are not using 'cookie' validation. Like this

$cfg['Servers'][$i]['auth_type'] = 'cookie';

Upvotes: 12

xan
xan

Reputation: 4696

Open Cpanel

Go To MySQLDatabases

Find MySQL Users

"Add new User"

Remember the username will be in the format domainname_username.

Upvotes: -1

Related Questions