| Robin |
 |
llama
Joined: 30 Jun 2004
Posts: 79
|
 Posted: Tue Feb 15, 2005 7:31 pm Post subject: guess I should post this here - creating database problem |
| |
This is what I'm putting in PHPMyAdmin:
| Quote: | mysql -u root -p
create database cms;
grant all privileges on cms.* to cms_user@localhost identified by 'cms_pass';
quit |
This is what it gives me:
| Quote: | #1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysql -u root -p
create database cms' at line 1 |
Oh and I don't get why, if I do it in cPanel, it puts robin_ before everything, but I suppose that's because it's a shared server. |
|
| Back to top |
|
| NetHosted - Andrew |
|
NetHosted Staff
Joined: 22 Mar 2004
Posts: 5684
|
| Posted: Tue Feb 15, 2005 8:13 pm Post subject: |
| |
You're not user root for starters!
It puts robin for exactly the reason you guessed, otherwise people might try and create the same database name as you and it could get very messy.
Just use the cPanel tool to create a new database!
Andrew
_________________
| Andrew Bassett
| Managing Director, NetHosted Ltd.
| Resellers, take a look at overselling  !
| Members, tell us what you think of NetHosted! |
|
| Back to top |
|
| Robin |
|
llama
Joined: 30 Jun 2004
Posts: 79
|
| Posted: Tue Feb 15, 2005 9:25 pm Post subject: |
| |
| NetHosted - Andrew wrote: | You're not user root for starters!
It puts robin for exactly the reason you guessed, otherwise people might try and create the same database name as you and it could get very messy.
Just use the cPanel tool to create a new database!
Andrew |
Well, the thing is, I'm trying to install a CMS called CMS made simple (www.cmsmadesimple.com) and the install file says I need to do this.
On http://opensourcecms.org it states that all the CMSes they have don't actually have to be in the root directory though, so it should work.
I guess I'll just have to figure out how.
Last edited by Robin on Wed Feb 16, 2005 7:56 am; edited 1 time in total |
|
| Back to top |
|
| NetHosted - Andrew |
|
NetHosted Staff
Joined: 22 Mar 2004
Posts: 5684
|
| Posted: Tue Feb 15, 2005 9:28 pm Post subject: |
| |
Robin,
I'm sure cmsmadesimple doesn't need you to create a database via phpMyAdmin - a database is a database no different if it is created via phpMyAdmin or the much simpler cPanel tool!
Andrew
_________________
| Andrew Bassett
| Managing Director, NetHosted Ltd.
| Resellers, take a look at overselling !
| Members, tell us what you think of NetHosted! |
|
| Back to top |
|
| NetHosted - Mark |
|
NetHosted Staff
Joined: 21 Dec 2004
Posts: 217
|
| Posted: Wed Feb 16, 2005 6:42 am Post subject: |
| |
to create a new database in phpmyadmin goto the home page and fill out the box there that says create database or similar.
THe commans you were using is what us sysadmins do when we remote login to the server commandline 
_________________
| Mark
| Customer Service & Sales, NetHosted Ltd
| Resellers, take a look at overselling !
| Members, tell us what you think of NetHosted! |
|
| Back to top |
|
| Robin |
|
llama
Joined: 30 Jun 2004
Posts: 79
|
| Posted: Wed Feb 16, 2005 6:54 am Post subject: |
| |
| Yeah.. the only problem is, I don't know how to create a database called 'cms' since robin_ is always put in front of it.. |
|
| Back to top |
|
| NetHosted - Mark |
|
NetHosted Staff
Joined: 21 Dec 2004
Posts: 217
|
| Posted: Wed Feb 16, 2005 7:02 am Post subject: |
| |
Simple answer: you cant.
Not-So-Simple-Answer: create cms - it'll be called robin_cms - tell your cms app thats what its called in its config file. If you cant, you need another one 
_________________
| Mark
| Customer Service & Sales, NetHosted Ltd
| Resellers, take a look at overselling !
| Members, tell us what you think of NetHosted! |
|
| Back to top |
|
| Robin |
|
llama
Joined: 30 Jun 2004
Posts: 79
|
| Posted: Wed Feb 16, 2005 7:55 am Post subject: |
| |
| NetHosted - Mark wrote: | Simple answer: you cant.
Not-So-Simple-Answer: create cms - it'll be called robin_cms - tell your cms app thats what its called in its config file. If you cant, you need another one |
Alright, seems like a good idea. I'll see if the config file is still blank or not.
Nope, the config file is blank. I'll just have to ask for help on the cmsmadesimple forums. Or I could try another CMS.. hmm..
Another edit: I figured I should try to give cms_user@localhost all privileges, but this is what it said: | Quote: | SQL-query:
GRANT ALL PRIVILEGES ON cms . * TO cms_user@localhostIDENTIFIED BY 'cms_pass'
MySQL said:
#1044 - Access denied for user: 'robin@localhost' to database 'cms' |
|
|
| Back to top |
|
| Robin |
|
llama
Joined: 30 Jun 2004
Posts: 79
|
| Posted: Wed Feb 16, 2005 10:47 am Post subject: |
| |
Alright, turns out I can do it by going here: http://lamahange.net/cms/install/install.php and create the database there, but whatever I do it says:
| Quote: | Warning: mysql_connect(): Access denied for user: 'robin_Robin@localhost' (Using password: YES) in /home/robin/public_html/cms/lib/adodb/drivers/adodb-mysql.inc.php on line 339
Connection failed |
Which means my user/password is wrong, as far as I know. I tried almost any combination I know, but I can't seem to get it right. (yet)
By the way, user/pass is still the same as what you guys gave me. |
|
| Back to top |
|
| NetHosted - Andrew |
|
NetHosted Staff
Joined: 22 Mar 2004
Posts: 5684
|
| Posted: Wed Feb 16, 2005 12:00 pm Post subject: |
| |
That's not the username and pass you should be using. You should be using the username/pass of the MySQL user you added to the database it is trying to connect too...
Andrew
_________________
| Andrew Bassett
| Managing Director, NetHosted Ltd.
| Resellers, take a look at overselling !
| Members, tell us what you think of NetHosted! |
|
| Back to top |
|
| Robin |
|
llama
Joined: 30 Jun 2004
Posts: 79
|
| Posted: Wed Feb 16, 2005 1:45 pm Post subject: |
| |
| NetHosted - Andrew wrote: | That's not the username and pass you should be using. You should be using the username/pass of the MySQL user you added to the database it is trying to connect too...
Andrew |
Which is the same. |
|
| Back to top |
|
| NetHosted - Andrew |
|
NetHosted Staff
Joined: 22 Mar 2004
Posts: 5684
|
| Posted: Wed Feb 16, 2005 1:58 pm Post subject: |
| |
No it's not. It'd be something like:
robin_username
pass
Andrew
_________________
| Andrew Bassett
| Managing Director, NetHosted Ltd.
| Resellers, take a look at overselling !
| Members, tell us what you think of NetHosted! |
|
| Back to top |
|
| Robin |
|
llama
Joined: 30 Jun 2004
Posts: 79
|
| Posted: Wed Feb 16, 2005 1:59 pm Post subject: |
| |
| NetHosted - Andrew wrote: | No it's not. It'd be something like:
robin_username
pass
Andrew |
oh that, well it's robin_Robin
pass |
|
| Back to top |
|
| NetHosted - Andrew |
|
NetHosted Staff
Joined: 22 Mar 2004
Posts: 5684
|
| Posted: Wed Feb 16, 2005 2:41 pm Post subject: |
| |
I just installed it for you no problems - I added another user to your DB one I created myself robin_cms as naturally I didn't know the passwords of your other two users.
Your CMS is installed here: http://lamahange.net/cms/
Andrew
_________________
| Andrew Bassett
| Managing Director, NetHosted Ltd.
| Resellers, take a look at overselling !
| Members, tell us what you think of NetHosted! |
|
| Back to top |
|
| Robin |
|
llama
Joined: 30 Jun 2004
Posts: 79
|
| Posted: Wed Feb 16, 2005 4:08 pm Post subject: |
| |
| NetHosted - Andrew wrote: | I just installed it for you no problems - I added another user to your DB one I created myself robin_cms as naturally I didn't know the passwords of your other two users.
Your CMS is installed here: http://lamahange.net/cms/
Andrew |
Wow thanks, that's really cool. I really don't get why I couldn't do it, it was weird. I probably overlooked something very trivial or something, I don't know.
Gotta love that nethosted customer service that takes care of everything. You make me lazy  |
|
| Back to top |
|
User Permissions |
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You can download files in this forum
|
| |
Client Support
