Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > Programming/Scripts

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 27th February 2008, 18:13
DankSherman DankSherman is offline
Junior Member
 
Join Date: Feb 2008
Location: Spain
Posts: 5
Thanks: 4
Thanked 0 Times in 0 Posts
Default phpMyAdmin Grant Privilege problem

So I recently uploaded a mail/newsletter script to my website. When I tested it by entering an address in the submit form I got the following error:

Query failed : INSERT command denied to user 'ericbrotto'@'server213-171-219-3.livedns.org.uk' for table 'mailinglist_subscribers'

I then noticed that there were "No Privileges" on my database, so I attempted to use SQL to grant one using the following command:

GRANT Insert
ON Ingles.*
TO 'ericbrotto'@'213-171-219-3.livedns.org.uk'
IDENTIFIED BY 'a fake password';

but the same response keeps coming up:

MySQL said:

#1410 - You are not allowed to create a user with GRANT.

This is strange because I had already created the user with my hosting company.

Any knowledge on this?!?!?
Reply With Quote
Sponsored Links
  #2  
Old 28th February 2008, 19:50
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,741 Times in 2,575 Posts
Default

Did you run this command as the MySQL root user?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
The Following User Says Thank You to falko For This Useful Post:
DankSherman (29th February 2008)
  #3  
Old 28th February 2008, 22:19
DankSherman DankSherman is offline
Junior Member
 
Join Date: Feb 2008
Location: Spain
Posts: 5
Thanks: 4
Thanked 0 Times in 0 Posts
Default I havent got it figured out yet...

First I uploaded the phpMyAdmin script to my website. I then configured the config.inc.php script and uploaded that.

I then went to the phpmyadmin/admin folder on my site. I assume at this point Im automatically logged in as the root user, no? Or is there a special process to logging in as the root user? It seems as if everything is okay as I can see my databases, can create tables, etc.

Im a beginner to this and sometimes explicit instructions are necessary. Ive searched for hours on the web trying to solve this on my own, but no luck.

Thanks for the quick response by the way...
Reply With Quote
  #4  
Old 29th February 2008, 07:59
topdog topdog is offline
Senior Member
 
Join Date: Jan 2008
Location: South Africa
Posts: 1,352
Thanks: 0
Thanked 153 Times in 150 Posts
Default

You need to be logged in as root or as a user that has grant privileges to be able to grant privileges to other users.

What kind of service are you running on is it a VPS where you have root access, or a dedicated server or its shared hosting.

With shared hosting you will probably have to ask your systems admin to fix this for you.
__________________
----
http://www.topdog.za.net - Got Linux problems ? - I can help.
http://www.baruwa.org - Try it.
Reply With Quote
The Following User Says Thank You to topdog For This Useful Post:
DankSherman (29th February 2008)
  #5  
Old 29th February 2008, 14:00
DankSherman DankSherman is offline
Junior Member
 
Join Date: Feb 2008
Location: Spain
Posts: 5
Thanks: 4
Thanked 0 Times in 0 Posts
Default

Im pretty sure its a VPS. The thing is Im the one that purchased the hosting package so its me who set up the database and its users with my hosting company. I also set up the passwords. Heck, I did everything!!!

I really dont understand how to log in as root user. Is there some steps that I need to take after going to the phpMyAdmin/admin folder? I dont see any log in links.

What I do see is two databases listed on the left hand side under the phpMyAdmin icons. One called information_schema and another one that I created. I also managed to create some tables on my database, which makes me feel like Im logged in already.

So confusing.... Can anyone clarify?
Reply With Quote
  #6  
Old 29th February 2008, 14:06
topdog topdog is offline
Senior Member
 
Join Date: Jan 2008
Location: South Africa
Posts: 1,352
Thanks: 0
Thanked 153 Times in 150 Posts
Default

From what you explain it seems like you have a hosting package not a full VPS, with a VPS you have actual control of the whole server and can login as root, are you sure you are not on a shared system with several users using the same database ?

On a VPS phpmyadmin would have to connect as the root user to have root privileges
__________________
----
http://www.topdog.za.net - Got Linux problems ? - I can help.
http://www.baruwa.org - Try it.
Reply With Quote
The Following User Says Thank You to topdog For This Useful Post:
DankSherman (29th February 2008)
  #7  
Old 29th February 2008, 14:24
DankSherman DankSherman is offline
Junior Member
 
Join Date: Feb 2008
Location: Spain
Posts: 5
Thanks: 4
Thanked 0 Times in 0 Posts
Default

My apologies. You are correct. I have a hosting package. Thank you very much for clarifying that...

But Im still left with my problem. All I want to do is grant certain privileges so that my script functions. As you can see from my original post, Im having problems doing that.

Any advice?
Reply With Quote
  #8  
Old 29th February 2008, 14:34
topdog topdog is offline
Senior Member
 
Join Date: Jan 2008
Location: South Africa
Posts: 1,352
Thanks: 0
Thanked 153 Times in 150 Posts
 
Default

Quote:
Originally Posted by DankSherman
My apologies. You are correct. I have a hosting package. Thank you very much for clarifying that...

But Im still left with my problem. All I want to do is grant certain privileges so that my script functions. As you can see from my original post, Im having problems doing that.

Any advice?
Speak to your hosting provider they will be able to do that for you.
__________________
----
http://www.topdog.za.net - Got Linux problems ? - I can help.
http://www.baruwa.org - Try it.
Reply With Quote
Reply

Bookmarks

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

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
phpMyAdmin log out problem ikaros HOWTO-Related Questions 8 25th August 2012 10:37
sending e-mail using mail() function linuxuser1 HOWTO-Related Questions 38 21st April 2009 12:20
Salutatory Email for Clients and Phpmyadmin problem krishol Installation/Configuration 10 16th August 2007 06:00
phpmyadmin configuration problem pushembekar Installation/Configuration 8 9th March 2006 21:48
phpMyAdmin install problem selcouth Installation/Configuration 8 20th November 2005 21:42


All times are GMT +2. The time now is 07:03.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.