Re: Access denied to mysql database using w2K professional
Sam and Anand
Thanks but I checked the error log and discovered that I have a bad host error and host is not allowed access to mysqld. These are a few of the error logs
Couldn't uncompress communication packet
Could not initialize master info structure, check permisions on master.info
ER_SLAVE_THREAD 1202 "Could not create slave thread, check system resources
ER_MASTER_FATAL_ERROR_READING_BINLOG 1236 "Got fatal error
ER_NET_READ_INTERRUPTED 1159 "Got timeout reading communication packets
ER_CRASHED_ON_REPAIR 1195
"Table '%-.64s' is marked as crashed and last (automatic?) repair failed",
#define ER_WARNING_NOT_COMPLETE_ROLLBACK 1196
"Warning: Some non-transactional changed tables couldn't be rolled back",
#define ER_TRANS_CACHE_FULL 1197
"Multi-statement transaction required more than 'max_binlog_cache_size' bytes of storage. Increase this mysqld variable and try again',
#define ER_SLAVE_MUST_STOP 1198
"This operation cannot be performed with a running slave, run SLAVE STOP first",
#define ER_SLAVE_NOT_RUNNING 1199
"This operation requires a running slave, configure slave and do SLAVE START",
#define ER_BAD_SLAVE 1200
"The server is not configured as slave, fix in config file or with CHANGE MASTER TO",
#define ER_MASTER_INFO 1201
"Could not initialize master info structure, check permisions on master.info",
#define ER_SLAVE_THREAD 1202
"Could not create slave thread, check system resources",
#define ER_TOO_MANY_USER_CONNECTIONS 1203
"User %-.64s has already more than 'max_user_connections' active connections",
#define ER_SET_CONSTANTS_ONLY 1204
"
When mysql is installed there are no user files installed and all privileges are denied. I am unable to edit any of the privileges to change to 'Y'.
I do not have proper access to the server hence no access to the mysqld. How might I fix this. Remember to give clear and simple instructions cos I'm a real novice. I am working on a standalone PC at the moment.
Great help needed. Thanks