phpmyadmin

How to require SSL for all remote users

by

The (formerly) accepted answer by Honza seems incorrect, see its comments. It seems not possible to use a GRANT query to alter multiple users at once since MySQL does not support wildcards for user names. As you suggested yourself you can alter records in the mysql.user table directly using an UPDATE query and as Marc … Read more

Composite key as foreign key (sql)

by

Per the mySQL documentation you should be able to set up a foreign key mapping to composites, which will require you to create the multiple columns. Add the columns and put this in your group table FOREIGN KEY (`beggingTime`,`day`,`tutorId`) REFERENCES tutorial(`beggingTime`,`day`,`tutorId`) As Steven has alluded to in the below comments, you SHOULD try to re-architect … Read more

phpMyAdmin says no privilege to create database, despite logged in as root user

by

Login using the system maintenance user and password created when you installed phpMyAdmin. It can be found in the debian.cnf file at /etc/mysql then you will have total access. sudo nano /etc/mysql/debian.cnf Just look – don’t change anything! [mysql_upgrade] host = localhost user = debian-sys-maint <—-use this user password = s0meRaND0mChar$s <—-use this password socket … Read more

How to add on delete cascade and on update restrict using phpmyadmin?

by

In the tab where you define the table structure, you get the list of columns and their properties and underneath that there should be a link “relation view“, between “print view”, and “propose table structure.” That’s where you want to go, but you have to have created the index on both tables already. Also, you … Read more

tech