nixCraft
Linux / UNIX Tech Support Forum
no privileges in phpMyAdmin
This is a discussion on no privileges in phpMyAdmin within the Databases servers forums, part of the Mastering Servers category; Salamo Alikom i had install MySQL 5.1.33 binary version for FreeBSD ,when i logging to phpMyAdmin as root i see ...
Register free or login to your account to remove all advertisements.
|
|||||||
| Databases servers Discussions of databases of all types - especially MySQL. |
 |
|
|
Thread Tools | Display Modes |
29th June 2009, 04:30 AM
|
|||
|
|||
no privileges in phpMyAdmin
Salamo Alikom
i had install MySQL 5.1.33 binary version for FreeBSD ,when i logging to phpMyAdmin as root i see no privilege to create database ,how can i solve this problem ? Last edited by nixcraft; 29th June 2009 at 11:48 AM. 
|
|
29th June 2009, 08:24 PM
|
||||
|
||||
|
You need to use MySQL root account and not system root account password.
__________________
Vivek Gite  Be proud RHEL user, and let the world know about your enterprise choices! Join RedHat user group. Do you run a Linux? Let's face it, you need help! Cricket & IPL News Blog
|
|
29th June 2009, 11:49 PM
|
|||
|
|||
|
Code:
mysql -u root -p Code:
show databases;
|
|
30th June 2009, 05:58 AM
|
||||
|
||||
|
By default there are only two database. Did you created additional databases?
__________________
Vivek Gite Be proud RHEL user, and let the world know about your enterprise choices! Join RedHat user group. Do you run a Linux? Let's face it, you need help! Cricket & IPL News Blog
|
|
30th June 2009, 09:54 AM
|
||||
|
||||
|
Do you see errors at mysql prompt or with PHPMyADMIN web based software?
__________________
Raj Linux rulz. I have never turned back in my life ; I shall not do so today.. haha
|
|
30th June 2009, 10:15 AM
|
|||
|
|||
|
Quote:
Quote:
|
|
30th June 2009, 10:27 AM
|
||||
|
||||
|
You need to create a new database and grant permission. Those 3 are default. Did you configured phpmyadmin correctly under Linux?
__________________
Raj Linux rulz. I have never turned back in my life ; I shall not do so today.. haha
|
|
2nd July 2009, 06:32 PM
|
|||
|
|||
|
Quote:
|
|
3rd July 2009, 06:15 PM
|
|||
|
|||
|
What happens if you try https?
Btw phpmyadmin has some security issues, so you might want to check your phpmyadmin version or run apt-get update (if applicable). I removed my installation and replaced it with webmin wich is also a more advanced package.
|
|
3rd July 2009, 10:34 PM
|
|||
|
|||
|
Quote:
Quote:
|
|
|
|
| Tags |
| linux, mysql, mysql gui tools, mysql webmaster manager, php, phpmyadmin |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) |
|
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| phpmyadmin - warning problem | satimis | Web servers | 1 | 12th June 2009 12:37 PM |
| How to create user with admin privileges | enochalbert | All about FreeBSD/OpenBSD/NetBSD | 1 | 10th May 2009 04:06 AM |
| PHPMyAdmin Problems | JoeDively | Coding in General | 0 | 21st September 2007 09:30 PM |
| phpmyadmin question | paul555 | Databases servers | 2 | 13th July 2007 08:27 AM |
| PhpmyAdmin-Can browse/search some tables, but not others | blinton25 | Databases servers | 1 | 8th June 2007 11:28 PM |
All times are GMT +5.5. The time now is 08:46 PM.