Welcome to Geeklog, Anonymous Monday, December 23 2024 @ 07:17 am EST
Geeklog Forums
MySQL Misery
Michael J Wise
Anonymous
So after hitting "Next" on Step 2 of 2, I'm getting this:
1142: create command denied to user: 'geeklog@...' for table 'gl_access'
(where '...' is the FQDN of my server)
The docs are not quite as explicit as I would like in this instance, and I've just had to speed-read thru the MySQL manual to find out that I need to put the command 'USE geeklog' before the 'GRANT ALL ...' command in the docs/install.html page.
Here's the most recent GRANT ALL command:
GRANT ALL PRIVILEGES ON geeklog to geeklog@_N1_ IDENTIFIED BY '_N2_';
_N1_ is the FQDN of the server.
_N2_ is the password for user geeklog.
I'm reasonably certain that I have the name of the database or some other thang boluxed up, and could use some pointers on what should go where, because I have tried all the obvious-to-me combinations at this point.
Any pointers gleefully accepted.
Michael.
1142: create command denied to user: 'geeklog@...' for table 'gl_access'
(where '...' is the FQDN of my server)
The docs are not quite as explicit as I would like in this instance, and I've just had to speed-read thru the MySQL manual to find out that I need to put the command 'USE geeklog' before the 'GRANT ALL ...' command in the docs/install.html page.
Here's the most recent GRANT ALL command:
GRANT ALL PRIVILEGES ON geeklog to geeklog@_N1_ IDENTIFIED BY '_N2_';
_N1_ is the FQDN of the server.
_N2_ is the password for user geeklog.
I'm reasonably certain that I have the name of the database or some other thang boluxed up, and could use some pointers on what should go where, because I have tried all the obvious-to-me combinations at this point.
Any pointers gleefully accepted.
Michael.
7
7
Quote
Status: offline
mthomas
Forum User
Full Member
Registered: 04/18/04
Posts: 148
Use Webadmin or MySqlAdmin to create the geeklog db and create your user there, give the account full access to the MySQL then run the table creation scripts from hier as well, makes life soooo much easier. (Besure your account info is in the config file correctly. Account should have localhost access to be safe or just set it to 'any' then it won't matter
6
9
Quote
Status: offline
JohnVanVliet
Forum User
Full Member
Registered: 10/09/03
Posts: 161
i like ot use PhpMyAdmin to set up the account and an empty geeklog db , for new installs
7
8
Quote
All times are EST. The time is now 07:17 am.
- Normal Topic
- Sticky Topic
- Locked Topic
- New Post
- Sticky Topic W/ New Post
- Locked Topic W/ New Post
- View Anonymous Posts
- Able to post
- Filtered HTML Allowed
- Censored Content