NetBeans Forums
| View previous topic :: View next topic |
| Author |
Message |
logical_c
Joined: 27 Aug 2010
Posts: 13
|
 Posted: Fri Aug 27, 2010 1:55 pm Post subject: MySQL: can't "grant full access" to root |
 |
|
I'm working through the AffableBean tutorial (which is outstanding by the way). I've connected to MySQL just fine but creating of the new dB calls for granting full access to root.
But when I check the box to choose a dB user to grant full access to, root isn't there. The only choice is the other default user (pma).
Does root automatically have access given that that's how I connect to the database? If it matters, in MySQL, root has global privileges.
The tutorial says to select root from the drop-down list in NetBeans.
Thanks in advance. |
|
| Back to top |
|
 |
troy giunipero
Posted via mailing list.
|
| Posted: Sun Aug 29, 2010 9:42 am Post subject: MySQL: can't "grant full access" to root |
|
|
On 8/27/10 3:55 PM, logical_c wrote:
| Quote: | I'm working through the AffableBean tutorial (which is outstanding by the way). I've connected to MySQL just fine but creating of the new dB calls for granting full access to root.
But when I check the box to choose a dB user to grant full access to, root isn't there. The only choice is the other default user (pma).
Does root automatically have access given that that's how I connect to the database? If it matters, in MySQL, root has global privileges.
The tutorial says to select root from the drop-down list in NetBeans.
|
It does, but it's not necessary to connect with the root account, so
long as there is another account that can provide access to the
'affablebean' database. So if your 'pma' account has been granted
access to the database, you'll be fine in the tutorial. Keep in mind
that the Services window allows you to connect the IDE to your MySQL
server - this connection has nothing to do with whether the application
server (i.e., GlassFish) can access the MySQL server.
| Quote: | Thanks in advance.
|
|
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum
|
|
FAQ
Search
Memberlist
Register
Profile
Log in to check your private messages
Log in
