aaron_ginn Posted May 4, 2003 Posted May 4, 2003 My first post here... First, let me say that I just switched over from another hosting provider this week, and I am ecstatic with the service that TCH has provided thus far. I've increased my web space by an order of magnitude and doubled my allowable bandwidth for the same price I was paying at the other place. Add to that that the servers are screaming fast, and I'm one happy cat! Now on to my problem. I'm attempting to create a new MySQL database to use for an image gallery. When I try to create the database from phpMyAdmin via the CPanel, I get the following error: Error SQL-query : CREATE DATABASE `theginn_images` MySQL said: Access denied for user: 'theginn@localhost' to database 'theginn_images' Admittedly, I am a complete database newbie, so perhaps I'm doing something totally wrong. However, when I go to LOGOUT from phpMyAdmin, I get the following message: Wrong username/password. Access denied. So, I'm wondering if the interface won't allow me to create a database because it doesn't think I'm the owner. Do I need to login somewhere else before I can do any database management? I'm pretty confused here. Any help would be appreciated! Thanks, Aaron Quote
btrfld Posted May 4, 2003 Posted May 4, 2003 I believe you need to create the database and add users with 'Manage MySQL', which you'll find right above phpMyAdmin in cPanel. Once those things are accomplished, you can use phpMyAdmin to create the tables and such. Quote
denzil69 Posted May 19, 2003 Posted May 19, 2003 could i follow on this posting please?? im in exactly the same predicament.... im attempting to configure b2 log, it was going ok (thanks to the excellent support service ive received from TCH, especially Rick!) but when i try to open my page it returns an error message saying access to database denied. the database is there, set and ready to go, but my php files are denied access... any ideas would be really helpful... thanx Quote
denzil69 Posted May 19, 2003 Posted May 19, 2003 also... could anyone shed any light on why i cannot access my database when i try to view my site or preview a post.. yet when i post, it access' my database fine and stores it??? Quote
TCH-Sales Posted May 19, 2003 Posted May 19, 2003 You could put in a help desk ticket so we could be sure that you have the database set up correctly, other than that I'd reread the b2 install instructions and like the old saying goes.. If it doesn't work the first time, then try try again! Just think of it as a learning experiance. Quote
denzil69 Posted May 19, 2003 Posted May 19, 2003 the database was set up by the TCH help team for me... ive read and reread the instructions time and again, ive viewed the problem file using dreamweaver so i can break down its coding, etc, i see nothing wrong there. its really puzzling me, because i can blog to the database, i can edit blogs that are in there, on installation, the setup tests return everything ok, yet when i try to view posts or my site, i get the denied access error... ive annoyed the help team way too much in recent days, theyve been very patient, i thought maybe i could get the answer from the forums, i prefer to understand whats wrong and get my head around it, so next time i come across the problem i can sort it..... as it stands ive tried everything and got nowhere... Quote
Singer Posted May 30, 2003 Posted May 30, 2003 I've been trying to create a database with no luck. In CPanel, I clicked on phpMyAdmin, causing the "Welcome to phpMyAdmin 2.4.0" screen to be displayed. I tried to create a new database by specifying <site user id>_schedule as the database name and clicking on the "Create" button. (My main web site user id is used instead of <site user id>.) The following message was displayed: ------------------ Database <site user id>_schedule running on localhost Error SQL-query : CREATE DATABASE `<site user id>_schedule` MySQL said: Access denied for user: '<site user id>@localhost' to database '<site user id>_schedule' ----------------------- Sigh! I currently have one database (agbook1), created automatically when I installed the advanced guestbook. I read the previous posts, taking those into account, but no luck. Any ideas? Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.