no rights on a spec db,but -show databases- still shows it

2001-07-11 Thread Marco Kammerer
3.22.38 Hello guys I figured out how I can set up different user that are able to work on their own dbs. here is my command to add a db and a user; GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP ON bernddb.* TO bernduser@LOCALHOST IDENTIFIED BY '1234' But a questions: when I have added

users in mysql

2001-07-10 Thread Marco Kammerer
3.22.38 Hello guys I figured out how I can set up different user that are able to work on their own dbs. here is my command to add a db and a user; GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP ON bernddb.* TO bernduser@LOCALHOST IDENTIFIED BY '1234' But a questions: when I have added

inserting a colum into a existing table

2001-05-30 Thread Marco Kammerer
Hello I am writing a programm in java that is checking my mysql db if everything is correct, so that I can you that db later in my java programm to write datas into it! I am fresh to mysql, but I got everything so fare, that the prog is able to make a no root user with the appr. rights,