hellkvist.org

[Alexandr]

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?

[Peffis]

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.

[Alexandr]

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?

[Peffis]

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');