Accessing the MYSQL Political Knowledge Database

 

I have just started developing the political knowledge database. Much more will be added later. This is a continuation of an effort that I had started with another vendor in java and dropped when that isp became unreliable. This does not use java, only PHP and MyPHPadmin.

 

The following is a list of queries that one can do from this website.

 

Go to this link: 

 

http://billboushka.com/mysqladmin/ 

 

Log in with user = guest725  password =  31t618

 

This user has SELECT privileges only. It has no update, create, write, or administration privileged.

 

Go to the list of databases on the logon screen and pick out “POLKNOW”.  Click on the window SQL on the upper left.

 

Here are some typical queries,

 

 

SELECT * FROM `argtb` WHERE 1 

 

SELECT `argtb` . * FROM argtb LIMIT 0, 30 ; 

 

SELECT `incident` . * FROM incident LIMIT 0, 30 ;  

 

SELECT `argtb` . `srcecode` , `argtb` . `stateargument` , `incident` . `srcecode` FROM argtb , incident WHERE `argtb` . `srcecode` = `incident` . `srcecode` ORDER BY `argtb` . `srcecode` ASC , `argtb` . `stateargument` ASC , `incident` . `srcecode` ASC LIMIT 0, 30 ;

 

This user does not allow anything that can update the databases.

 

For example:

Error

SQL query: Edit

INSERT INTO `argtb` ( `stmtcode` , `srcecode` , `argcd` , `cntcd` , `author` , `publ` , `argname` , `stateargument` , `argdes` , `publdes` , `cntcd2` , `fielddes1` , `fielddes2` , `resolution` , `flaw` )
VALUES (

'test', 'test', 'test', 'test', 'test', 'test', 'test', 'test', 'test', 'test', 'test', 'test', 'test', '0', '0'

)

MySQL said: Documentation

#1044 - Access denied for user 'guest725'@'bill46.veriomysql.com' to database 'polknow'