Weird MySql Error.. help please!

Status
Not open for further replies.

stoltpk

New Member
Messages
3
Reaction score
0
Points
0
Okay, my problem is, when i try to Import my sql database on phpMyAdmin i get an error.
no matter what i do, im always logged in as "stoltpk@localhost" :sad:


error on import:
#1142 - CREATE command denied to user 'stoltpk'@'localhost' for table 'server_reports'

i have tried to make a database named the name of my import, and give full prevligies to my desidred name, but it wont work! still logged in as stoltpk@localhost.

somone, please help.
 
Last edited:

MaestroFX1

Community Advocate
Community Support
Messages
1,577
Reaction score
60
Points
0
You need to grant the "user" of your MySQL database the right privileges for security access.
You should grant at least: SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER permissions.
************
Also check
- username
- password
- database name
- database host/server
- security settings on your database

When you created your database, did you grant the user access to the database?

Proper database-configuration includes:
- make a database
- make a user, with password
- grant the user permission to use the database
 
Status
Not open for further replies.
Top