phpMyAdmin privileges!! Help !!!

Connect with other users about what to run on your webhosting (and how to run it) here.
Post Reply
lncketchum
New to forums
New to forums
Posts: 5
https://www.youtube.com/channel/UC40BgXanDqOYoVCYFDSTfHA
Joined: Thu Feb 24, 2005 12:09 pm

phpMyAdmin privileges!! Help !!!

Post by lncketchum »

I finally got phpmyadmin working almost flawlessly on my server but for some reason when trying 2 create a new database, it says I have no access i.e privileges to do that!!! :(
What have I done wrong?? Please help

* Server(s) configuration
*/
$i = 0;
// The $cfg['Servers'] array starts with $cfg['Servers'][1]. Do not use $cfg['Servers'][0].
// You can disable a server config entry by setting host to ''.
$i++;
$cfg['Servers'][$i]['host'] = 'localhost'; // MySQL hostname or IP address
$cfg['Servers'][$i]['port'] = ''; // MySQL port - leave blank for default port
$cfg['Servers'][$i]['socket'] = ''; // Path to the socket - leave blank for default socket
$cfg['Servers'][$i]['connect_type'] = 'socket'; // How to connect to MySQL server ('tcp' or 'socket')
$cfg['Servers'][$i]['extension'] = 'mysql'; // The php MySQL extension to use ('mysql' or 'mysqli')
$cfg['Servers'][$i]['compress'] = FALSE; // Use compressed protocol for the MySQL connection
// (requires PHP >= 4.3.0)
$cfg['Servers'][$i]['controluser'] = 'ua'; // MySQL control user settings
// (this user must have read-only
$cfg['Servers'][$i]['controlpass'] = '*****'; // access to the "mysql/user"
// and "mysql/db" tables).
// The controluser is also
// used for all relational
// features (pmadb)
$cfg['Servers'][$i]['auth_type'] = 'cookie'; // Authentication method (config, http or cookie based)?
$cfg['Servers'][$i]['user'] = 'ua'; // MySQL user
$cfg['Servers'][$i]['password'] = '*****'; // MySQL password (only needed
// with 'config' auth_type)
$cfg['Servers'][$i]['only_db'] = ''; // If set to a db-name, only
// this db is displayed in left frame
// It may also be an array of db- names, where sorting order is relevant.
$cfg['Servers'][$i]['verbose'] = ''; // Verbose name for this host - leave blank to show the hostname
lncketchum
New to forums
New to forums
Posts: 5
Joined: Thu Feb 24, 2005 12:09 pm

ooopsy daisey!

Post by lncketchum »

Ahhhh !! 4get it! I'm a retard. I just realized we can only have 1 DB and I am already using it!!! :oops:
User avatar
Nick|NFo
Former staff
Former staff
Posts: 2252
Joined: Sun Mar 30, 2003 1:56 pm
Location: 127.0.0.1

Post by Nick|NFo »

Its ok, for security reasons we provide one database per webspace as well as management. You can use alot with that one database, simply organize your database using prefixes and it should go smoothly :)
-Nick
lncketchum
New to forums
New to forums
Posts: 5
Joined: Thu Feb 24, 2005 12:09 pm

Final Result

Post by lncketchum »

Got it all set up and running smoooooth!!! YaY :D
Post Reply