icon Get the most out of Surmunity, read our tips here! Need an interesting blog to read? You've got to read the Surpass Blog! | Welcome! Please register to access all of our features.

» Surpass Web Hosting Forums » Discussions » PHP, MySQL » Mysql Accont Maintenance Not Displaying Properly

PHP, MySQL General PHP questions. Or go to our PHPsuexec Forum >>

Closed Thread
 
LinkBack Thread Tools Search this Thread Rate Thread
Old September 22nd, 2003, 7:51 PM   #1 (permalink)
Registered User
Seasoned Poster
 
Joined in May 2003
34 posts
Gave thanks: 0
Thanked 0 times
After the trouble with the servers a couple weeks ago (or was it when cpanel was upgraded?), not sure but now the MySQL Account Maintenance does not display my current databases nor the users setup for it. Before the trouble or upgrade with the servers, I had 5 databases, one of which was actively used. After the upgrade or whatver, CPanel reads as this:

Mysql databases 0 / 9999
SQL Disk usage 0.00 Megabytes

PhpMyAdmin shows the five databases from before though...

Just now, I used Fantastico to setup an invision forum and it created a user but not a database. I then tried to create a database through MySQL Account Maintenance but no luck, I also wanted to see what would happen if I created my primary mysql user account (that I created a long time ago) and it said that the user already existed, so that shows that my account is still there, just that it's not being displayed at all.



Another thing that I addressed before but I guess not many other people have this problem. When installing the scripts with fantastico, it registers the user and database as kcuf.us_user and kcuf.us_database. It should set it up as kcufus_user and kcufus_database, without the period. That's how PhpMyAdmin shows up my databases. Well, I just tried creating a new database with MySQL Account Maintenance and it said that the database was created but it is not displayed, and I don't know of any other way to add a user to a database so I'm pretty much stuck because none of the users nor the databases are displayed.

Sorry for the long post but that's my current situation. Should I take this to support? :frust:
kcuf.us is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Old September 22nd, 2003, 7:56 PM   #2 (permalink)
the one who was
Super #1
 
patrickb's Avatar
 
Joined in Jul 2003
Lives in Memphis
1,967 posts
Gave thanks: 0
Thanked 3 times
Definitely a support ticket.. It seems you have a period in your username, and that is causing the various scripts to choke and not recognize the database, and would also explain why Cpanel doesn't see any of the old databases since it is looking for them under kcuf.us_ now when it used to look for kcufus_.
__________________
Patrick

Warnings: The program(s) might crash unexpectedly or behave otherwise strangely. (But of course, so do many commercial programs on Windows.) --www.gimp.org
patrickb is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Old October 3rd, 2003, 4:53 PM   #3 (permalink)
Registered User
Seasoned Poster
 
Joined in May 2003
34 posts
Gave thanks: 0
Thanked 0 times
Oops, I never updated on this situation. Well, everything got fixed, someone from tech fixed the period problem, all of my databases showed up again, Fantastico actually works now, I can finally view the statistics for my website, all the paths seem to be fixed. I had a problem with my subdomain ftp accounts and that got fixed as well. What can I say? Surpass support is great.
kcuf.us is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Old October 3rd, 2003, 5:25 PM   #4 (permalink)
the one who was
Super #1
 
patrickb's Avatar
 
Joined in Jul 2003
Lives in Memphis
1,967 posts
Gave thanks: 0
Thanked 3 times
:surpass: Yes
__________________
Patrick

Warnings: The program(s) might crash unexpectedly or behave otherwise strangely. (But of course, so do many commercial programs on Windows.) --www.gimp.org
patrickb is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Old October 3rd, 2003, 8:51 PM   #5 (permalink)
Registered User
Super #1
 
Joined in Jul 2003
Lives in So. NJ
1,557 posts
Gave thanks: 0
Thanked 9 times
Thanks for the update, kc.
__________________
Dime13 | Pass17
snide is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Closed Thread


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On