CREATE TABLE IF NOT EXISTS `mydb`.`language` ( `idlangues` TINYINT UNSIGNED NOT NULL , `Language_Name` VARCHAR(10) NOT NULL , PRIMARY KEY (`idlangues`) ) ENGINE = InnoDB; -- --- -- Table `mydb`.`Accomodation` -- --- DROP TABLE IF EXISTS `mydb`....
"jdbc:mysql://localhost/DBTeseus?user=MARCOS&password=1"); The code produces the following exception: java.sql.SQLException: Access denied for user 'MARCOS'@'localhost' (using password: YES) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) ...
3. I used mysql_install_db with --basedir, --datadir and --skip-name-resolve options 4. I use a user "dummy" (that belongs to the mysql group) : I can not create the mysql user (Windows prevent me from creating a mysql user for a reason I can't figure out : I stopped ...
Here's the trigger code (which loads to the database without error): DELIMITER // CREATE TRIGGER mydb.ctct_del AFTER DELETE ON mydb.contact FOR EACH ROW BEGIN if exists (select contact.id_ctct from mydb.contact where old.id_ctct = contact.id_ctct_rltd) then ...
CREATE TRIGGER `DB1`.`au_user_trigger` AFTER UPDATE ON `DB1`.`forum_user` FOR EACH ROW BEGIN IF NOT EXISTS(SELECT id FROM triggerlist WHERE id = NEW.userid) THEN BEGIN INSERT INTO triggerlist(id) VALUES (NEW.userid); UPDATE page_user ...
"jdbc:mysql://localhost/DBTeseus?user=MARCOS&password=1"); The code produces the following exception: java.sql.SQLException: Access denied for user 'MARCOS'@'localhost' (using password: YES) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) ...