hellkvist.org

[Thomas]

When I run usersetup.sql it game me this message in my phpmyadmin (see subject).

From the first table...sql there was no table db created.

I tried v1.0 and v0.9

Thanks for a supposently good program!

[Peffis]

Hi Thomas,

Unfortunately I have no experience at all with phpmyadmin so I'm not sure what is going wrong. I've always setup the database from command line. There seem to be some confusion though. There should never be a peffisaur.db table. Instead there should be a peffisaur database. Perhaps something has gone wrong here

[Peffis]

Before running the usersetup.sql btw, did you create the peffisaur database?

[Guest]

I think he's trying to execute that SQL on his peffisaur database and not his mySQL users database.

hth.

[sacr0]

I'm also trying to set this up via phpadmin as I don't have other access to the databases.

in the usersetup.sql


insert into db (host,db,user,select_priv,insert_priv,update_priv,delete_priv,create_priv,drop_priv,alter_priv)
values ('localhost','peffisaur','peffisaur','y','y','y','y','y','y','y');

# Please change the password below!!!!
insert into user (host,user,password)
values ('localhost','peffisaur',password('hush-hush'));

1/ Where/What is 'db'? database or table?
2/ Where/What is 'user' same again.

I have no experience with command line sql so I would have no idea where to start.

Maybe someone that has installed this, AND has phpmyadmin or whatever can do a dump of what is required

btw. Thanks Peffis for a very kewl script.

sacr0

[nfinland]

I have the same problem. First tried to execute usersetup on peffisaur database.

But how do I execute it to mySQL users database?

[Peffis]

Sorry, but my knowledge about phpadmin is equal to zero so I can't help you.

On the command line you always specify which database you want to use as an argument, like so: mysql -u peffisaur --password=XXXX mysql < usersetup.db


But usersetup is only to create the database user peffisaur. If you have a database user you can use that one instead. Or perhaps you can create database users somewhere else in the gui your webhost gives you. I know that on mine they have a separate interface to create database users and databases. Once you have the user and the database you can just start using it.