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 » New to MySQL

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

Reply
 
LinkBack Thread Tools Search this Thread Rate Thread
Old February 24th, 2006, 1:26 AM   #1 (permalink)
Master of his Domain
On a golden path...
 
SnakeMan's Avatar
 
Joined in Sep 2005
Lives in The Mountains
Hosted on Pass43
387 posts
Gave thanks: 20
Thanked 19 times
Question New to MySQL

I've never used MySQL so please be nice to this noob.

Attached is a screen shot from my Cp and I would like to know what exactly is put into the various boxes. What I want to do is put a CMS on a website I'm attempting to put together for a family website. I plan on using the e107 CMS since it seems to have what we want,

I just have no idea where to start.

Any and all help is greatle appreciated.

SnakeMan

Last edited by SnakeMan; May 10th, 2007 at 8:17 PM..
SnakeMan is online now  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old February 24th, 2006, 1:31 AM   #2 (permalink)
H
after g, before i
Resident.
 
H's Avatar
 
Joined in Jul 2004
Lives in N,BC,CA
8,230 posts
Gave thanks: 49
Thanked 136 times
Re: New to MySQL

First thing you do is create a database.

Second, you make a user and a password.

Third, you add that user to the database. You can ignore the checkboxes for simplicity sake, but in the future, you may want to learn what they mean to bring added security to your site.

Last edited by H; February 24th, 2006 at 1:38 AM..
H is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old February 24th, 2006, 1:36 AM   #3 (permalink)
Senior Member
Surpass Staff
 
Kayla's Avatar
 
Joined in May 2003
Lives in Orlando
25,189 posts
Gave thanks: 982
Thanked 879 times

Default Medal 
Total Awards: 1

Re: New to MySQL

Wow, excellent explanation there.
__________________
Add Surpass on Twitter and Facebook for great deals and contests FIRST!
Kayla is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old February 24th, 2006, 1:39 AM   #4 (permalink)
H
after g, before i
Resident.
 
H's Avatar
 
Joined in Jul 2004
Lives in N,BC,CA
8,230 posts
Gave thanks: 49
Thanked 136 times
Re: New to MySQL

But I spelled thing as 'think'. It's now corrected with my uber MySQL database hacking skills. Did I mention I once killed a MySQL server at the college?
H is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old February 24th, 2006, 1:57 AM   #5 (permalink)
Master of his Domain
On a golden path...
 
SnakeMan's Avatar
 
Joined in Sep 2005
Lives in The Mountains
Hosted on Pass43
387 posts
Gave thanks: 20
Thanked 19 times
Question Re: New to MySQL

Thanks Haugland.

Now another question...

The install instructions say to set permissions on certain files to 777 but I rememer reading here in the forums that 777 is not permitted anymore and I should set thm to 755 if I remember correctly. Is that correct?

SnakeMan
SnakeMan is online now  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old February 24th, 2006, 1:59 AM   #6 (permalink)
?™
Resident.
 
David's Avatar
 
Joined in Mar 2004
Lives in fear of Obama.
Hosted on Pass 7, Pass 78
14,157 posts
Gave thanks: 68
Thanked 53 times
Send a message via Skype™ to David
Re: New to MySQL

Some servers won't let you use it. You may be able to try 707 as well, but it just depends on the script you're using. I know some only check for 777, not if the permissions are enough.
__________________
I'm a web designer that founded the company Asheboro Creative. You can follow me on Twitter, add me on Myspace, or read my articles on Asheboro Tech.
David is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old February 24th, 2006, 2:19 AM   #7 (permalink)
Senior Member
Surpass Staff
 
Kayla's Avatar
 
Joined in May 2003
Lives in Orlando
25,189 posts
Gave thanks: 982
Thanked 879 times

Default Medal 
Total Awards: 1

Quote:
Originally Posted by SnakeMan
Thanks Haugland.

Now another question...

The install instructions say to set permissions on certain files to 777 but I rememer reading here in the forums that 777 is not permitted anymore and I should set thm to 755 if I remember correctly. Is that correct?

SnakeMan
You're on Pass43 which does not have phpsuexec enabled right now, so it's ok to set it to 777.

Later down the road, we can discuss the changes you would have to make.
__________________
Add Surpass on Twitter and Facebook for great deals and contests FIRST!
Kayla is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old February 24th, 2006, 2:40 AM   #8 (permalink)
Master of his Domain
On a golden path...
 
SnakeMan's Avatar
 
Joined in Sep 2005
Lives in The Mountains
Hosted on Pass43
387 posts
Gave thanks: 20
Thanked 19 times
Thanks David and Kayla.

Everything went fine until I got to the last step where I got the following error:

The installer could not select database: "snakeman_e107"

MySql Reported Error:
Access denied for user: 'snakeman_callocalhost' to database 'snakeman_e107"

I went back to my control panel and double checked the database name and it is correct and the username is also correct.

Any suggestions?

SnakeMan
SnakeMan is online now  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old February 24th, 2006, 2:47 AM   #9 (permalink)
?™
Resident.
 
David's Avatar
 
Joined in Mar 2004
Lives in fear of Obama.
Hosted on Pass 7, Pass 78
14,157 posts
Gave thanks: 68
Thanked 53 times
Send a message via Skype™ to David
Run through this and double check against what you've done:

http://www.ninehours.com/tutorials/4/

Sounds like your password might not be right.
__________________
I'm a web designer that founded the company Asheboro Creative. You can follow me on Twitter, add me on Myspace, or read my articles on Asheboro Tech.
David is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


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