 |
hellkvist.org Discussions about the free software on hellkvist.org
|
View previous topic :: View next topic |
Author |
Message |
Alexandr Guest
|
Posted: Mon Oct 04, 2004 7:39 pm Post subject: can't install DB |
|
|
Hi all, Stefan.
Your peffisaur is really cool! But there is one problem – I can’t install SQL database it on my server of my provider. That provider’s service answers all your requirements (MySQL, PHP etc). I can’t use your *.sql files and make it by using PHPMyAdmin. The tables of DateBase I made easy but I can’t perform follow commands:
insert into db (host,db,user,select_priv,insert_priv,update_priv,delete_priv,create_priv,drop_priv,alter_priv)
values ('localhost','asidaru','peffisaur','y','y','y','y','y','y','y');
where “asidaru” is the name of my database instead your “peffisaur”. My host provider doesn’t permit to make DB with any name L. So I replaced peffisaur by asidaru. The answer of PhpMyAdmin after above command are : #1046 - No Database Selected. (though my shell wrote me that current database is asidaru) or #1146 – table ‘asidaru.db’ doesn’t exist
could you advise me something? |
|
Back to top |
|
 |
Peffis Site Admin
Joined: 09 Sep 2003 Posts: 324 Location: Sweden
|
Posted: Mon Oct 04, 2004 8:14 pm Post subject: |
|
|
Sorry. I have never used PHPMyAdmin so I don't know how you do it there. But there must surely be a way to create databases and users in that tool as well, or? You probably don't have to do the insert into db (because you probably don't have the right to modify the mysql database) so there is surely some other way to create databases. But I'm only guessing. If it's not and you only have, say one database on your account, you can of course put all the tables into that database and change the database name in all your peffisaur php files. |
|
Back to top |
|
 |
Alexandr Guest
|
Posted: Wed Oct 06, 2004 10:51 am Post subject: |
|
|
Hello!
I have told with admin of that server. He said that expression
insert into db (host,db,user,select_priv,insert_priv,update_priv,delete_priv,create_priv,drop_priv,alter_priv)
values ('localhost','asidaru','peffisaur','y','y','y','y','y','y','y');
tried to give some privileges and that is banned just for security. Stefan, can I replace or not use this expression? |
|
Back to top |
|
 |
Peffis Site Admin
Joined: 09 Sep 2003 Posts: 324 Location: Sweden
|
Posted: Wed Oct 06, 2004 3:24 pm Post subject: |
|
|
I see, the only thing that the peffisaur needs to be able to do is to insert, update and delete. So if those options are allowed you can change the line into insert into db (host,db,user,select_priv,insert_priv,update_priv,delete_priv,create_priv,drop_priv,alter_priv)
values ('localhost','asidaru','peffisaur','y','y','y','n','n','n','n'); |
|
Back to top |
|
 |
|
|
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
|
Powered by phpBB © 2001, 2005 phpBB Group
|