: Trouble creating new MySQL user/database with PHPMyAdmin I did a brand new install of PHPMyAdmin and I managed to get it set up a while ago with a single non-admin user and a database. I

I did a brand new install of PHPMyAdmin and I managed to get it set up a while ago with a single non-admin user and a database.

I now want to add a new user and new database. So, I went to the command line and created the database, created sampleuser@localhost identified by 'password', and granted all privileges to that user to the new database.

When I go to PHPMyAdmin, however, I can't log in as sampleuser. I also tried to grant privilages to see the new database to my old user, and the database doesn't appear for my old user.

Is there something I need to do to get PHPMyAdmin to reflect the changes?

10.01% popularity Vote Up Vote Down

: Change Region For An Amazon RDS Instance I am using AWS free tier. While launching EC2 instance and RDS instance, I didn't choose any specific region. So, randomly I was assigned two different

@Cofer257

Posted in: #AmazonAws #AmazonEc2

1 Comments

: What is that Google web site management tool called? A year (or maybe 2) ago, Google announced they were working on releasing a management tool for static HTML sites. The idea is that you

@Cofer257

Posted in: #Google

1 Comments

: Merged Contents From Other Sites - SEO Effect I am working on an web app, part of which grab contents from other several sites and show them in a merged way (partial info). Those sites are

@Cofer257

Posted in: #Seo

3 Comments

: Pass IMG SRC via GET and echo it? Is that really secure? I was wondering how I can make a really simple GET and echo request more secure The code: $src = $_GET['src']; echo "<img src='$src'

@Cofer257

Posted in: #Php #QueryString #Security #Xss

1 Comments

Login to post a comment!

1 Comments

Sorted by latest first Latest Oldest Best

@Gretchen104

You have to configure PHPMyAdmin to connect to the MySQL database first. If you go to wiki.phpmyadmin.net/pma/Config you'll see that you need to add the following example to your config.inc.php file:

$cfg['Servers'][$i]['host'] = 'localhost'; // MySQL hostname
$cfg['Servers'][$i]['port'] = ''; // MySQL port (leave blank for 3306)
$cfg['Servers'][$i]['connect_type'] = 'tcp'; // If the MySQL hostname is a socket, then this needs to be set to socket instead of tcp
$cfg['Servers'][$i]['user'] = 'u130247'; // MySQL username
$cfg['Servers'][$i]['password'] = 'GCpNMDZJf9q47umx'; // MySQL database
$cfg['Servers'][$i]['only_db'] = ''; // MySQL database name

You should have also configured the login and password to get into PHPMyAdmin already. If you haven't then see wiki.phpmyadmin.net/pma/Quick_Install
(The username and password are taken from the PHPMyAdmin documention so they're not mine or someone else login for their MySQL database.)

10% popularity Vote Up Vote Down

Feed

: Trouble creating new MySQL user/database with PHPMyAdmin I did a brand new install of PHPMyAdmin and I managed to get it set up a while ago with a single non-admin user and a database. I

More posts by @Cofer257

: Change Region For An Amazon RDS Instance I am using AWS free tier. While launching EC2 instance and RDS instance, I didn't choose any specific region. So, randomly I was assigned two different

: What is that Google web site management tool called? A year (or maybe 2) ago, Google announced they were working on releasing a management tool for static HTML sites. The idea is that you

: Merged Contents From Other Sites - SEO Effect I am working on an web app, part of which grab contents from other several sites and show them in a merged way (partial info). Those sites are

: Pass IMG SRC via GET and echo it? Is that really secure? I was wondering how I can make a really simple GET and echo request more secure The code: $src = $_GET['src']; echo "<img src='$src'

Login to post a comment!

1 Comments

Back to top | Use Dark Theme