nixCraft Linux Forum

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 ...


Go Back   nixCraft Linux Forum > Mastering Servers > Databases servers

Linux answers from nixCraft.


Databases servers Discussions of databases of all types - especially MySQL.

Reply

 

LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 29-06-2009, 04:30 AM
Junior Member
User
 
Join Date: Jun 2009
OS: FreeBSD
Posts: 5
Thanks: 2
Thanked 0 Times in 0 Posts
Rep Power: 0
SIFE is on a distinguished road
Default 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; 29-06-2009 at 11:48 AM.
Reply With Quote
  #2 (permalink)  
Old 29-06-2009, 08:24 PM
nixcraft's Avatar
Never say die
User
 
Join Date: Jan 2005
Location: BIOS
OS: RHEL
Scripting language: Bash and Python
Posts: 2,710
Thanks: 11
Thanked 245 Times in 184 Posts
Rep Power: 10
nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute
Default

You need to use MySQL root account and not system root account password.
__________________
Vivek Gite
Linux Evangelist
Be proud RHEL user, and let the world know about your enterprise choices! Join RedHat user group.
Always use CODE tags for posting system output and commands!
Do you run a Linux? Let's face it, you need help
Reply With Quote
  #3 (permalink)  
Old 29-06-2009, 11:49 PM
Junior Member
User
 
Join Date: Jun 2009
OS: FreeBSD
Posts: 5
Thanks: 2
Thanked 0 Times in 0 Posts
Rep Power: 0
SIFE is on a distinguished road
Default

Code:
mysql -u root -p
i did but it is steal show me the same message and when i execute this query :
Code:
show databases;
the result is only two databases .
Reply With Quote
  #4 (permalink)  
Old 30-06-2009, 05:58 AM
nixcraft's Avatar
Never say die
User
 
Join Date: Jan 2005
Location: BIOS
OS: RHEL
Scripting language: Bash and Python
Posts: 2,710
Thanks: 11
Thanked 245 Times in 184 Posts
Rep Power: 10
nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute nixcraft has a reputation beyond repute
Default

By default there are only two database. Did you created additional databases?
__________________
Vivek Gite
Linux Evangelist
Be proud RHEL user, and let the world know about your enterprise choices! Join RedHat user group.
Always use CODE tags for posting system output and commands!
Do you run a Linux? Let's face it, you need help
Reply With Quote
  #5 (permalink)  
Old 30-06-2009, 09:54 AM
raj's Avatar
raj raj is offline
Senior Member
User
 
Join Date: Jun 2005
Location: Hyderabad
OS: Fedora, Debian Linux
Posts: 307
Thanks: 42
Thanked 8 Times in 8 Posts
Rep Power: 6
raj will become famous soon enough raj will become famous soon enough
Default

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
Reply With Quote
  #6 (permalink)  
Old 30-06-2009, 10:15 AM
Junior Member
User
 
Join Date: Jun 2009
OS: FreeBSD
Posts: 5
Thanks: 2
Thanked 0 Times in 0 Posts
Rep Power: 0
SIFE is on a distinguished road
Default

Quote:
By default there are only two database. Did you created additional databases?
i think there are 3 :mysql ,test , information if i did not forget .
Quote:
Do you see errors at mysql prompt or with PHPMyADMIN web based software?
there is not .
Reply With Quote
  #7 (permalink)  
Old 30-06-2009, 10:27 AM
raj's Avatar
raj raj is offline
Senior Member
User
 
Join Date: Jun 2005
Location: Hyderabad
OS: Fedora, Debian Linux
Posts: 307
Thanks: 42
Thanked 8 Times in 8 Posts
Rep Power: 6
raj will become famous soon enough raj will become famous soon enough
Default

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
Reply With Quote
  #8 (permalink)  
Old 02-07-2009, 06:32 PM
Junior Member
User
 
Join Date: Jun 2009
OS: FreeBSD
Posts: 5
Thanks: 2
Thanked 0 Times in 0 Posts
Rep Power: 0
SIFE is on a distinguished road
Default

Quote:
Originally Posted by raj View Post
You need to create a new database and grant permission. Those 3 are default. Did you configured phpmyadmin correctly under Linux?
yes . i did i ha configured phpMyAdmin to be as http authentication .
Reply With Quote
  #9 (permalink)  
Old 03-07-2009, 06:15 PM
Junior Member
User
 
Join Date: May 2009
Location: Amsterdam
OS: SUSE
Posts: 17
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
Clinton is on a distinguished road
Default

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.
Reply With Quote
  #10 (permalink)  
Old 03-07-2009, 10:34 PM
Junior Member
User
 
Join Date: Jun 2009
OS: FreeBSD
Posts: 5
Thanks: 2
Thanked 0 Times in 0 Posts
Rep Power: 0
SIFE is on a distinguished road
Default

Quote:
What happens if you try https?
it is already http authorization ,second i am running my server in localhost .
Quote:
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.
but when i login to MySQL server as root to create database ,the server show me message after query that is tell me i have no privilege .
Reply With Quote
Reply

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads

Thread Thread Starter Forum Replies Last Post
phpmyadmin - warning problem satimis Web servers 1 12-06-2009 12:37 PM
How to create user with admin privileges enochalbert All about FreeBSD/OpenBSD/NetBSD 1 10-05-2009 04:06 AM
PHPMyAdmin Problems JoeDively Coding in General 0 21-09-2007 09:30 PM
phpmyadmin question paul555 Databases servers 2 13-07-2007 08:27 AM
PhpmyAdmin-Can browse/search some tables, but not others blinton25 Databases servers 1 08-06-2007 11:28 PM


All times are GMT +5.5. The time now is 08:45 PM.


Powered by vBulletin® Version 3.8.5 - Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.3.2
©2005-2010 nixCraft. All rights reserved

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38