PHPFixing
  • Privacy Policy
  • TOS
  • Ask Question
  • Contact Us
  • Home
  • PHP
  • Programming
  • SQL Injection
  • Web3.0

Tuesday, February 22, 2022

[FIXED] phpmyadmin don't see new created databases

 February 22, 2022     mysql, mysqli, php, phpmyadmin     No comments   

Issue

I create db via mysql:

CREATE DATABASE `my_db` CHARACTER SET utf8 COLLATE utf8_general_ci;

mysql>show databases - my_db is shown,

then i'm login to phpmyadmin and don't see this db, only - information_schema, phpmyadmin, test

p.s. ubuntu 12.04, mysql 5, phpmyadmin 3.4.10.1deb1


Solution

You need to give your user access to that database, log into phpMyAdmin as the mysql administrator, go to the database in question and click on "permissions", then proceed to add your desired users to the database. Alternatively you can use the mysql client and issue the commands as SQL such as:

GRANT ALL ON db1.* TO 'finn'@'localhost';

http://dev.mysql.com/doc/refman/5.0/en/grant.html



Answered By - functionvoid
  • Share This:  
  •  Facebook
  •  Twitter
  •  Stumble
  •  Digg
Newer Post Older Post Home

0 Comments:

Post a Comment

Note: Only a member of this blog may post a comment.

Total Pageviews

Featured Post

Why Learn PHP Programming

Why Learn PHP Programming A widely-used open source scripting language PHP is one of the most popular programming languages in the world. It...

Subscribe To

Posts
Atom
Posts
Comments
Atom
Comments

Copyright © PHPFixing