Hello Folks, it’s has been a while I didn’t write new articles, it’s has been a while I didn’t write new articles, so time to give back to the community, I will describe how to implement MySQL cluster for high-availability and disturbed workload MySQL Cluster Architect comes with new process ndbd and ndb_mgmd ndb is used […]
hello everyone today we will make MySQL Docker Container with Shared Storage first let’s pull latest MySQL version of docker
|
1 |
docker pull mysql |
after we did download the latest image this image come in handy with some awesome parameters MYSQL_ROOT_PASSWORD MYSQL_DATABASE with this parameters, we can create a database and set root password for mysql now let’s create a […]
#1146 – Table ‘phpmyadmin.pma_tracking’ doesn’t exist this error indicates that phpmyadmin pages failed in setup and you just ignored it in the setup process you need to reconfigure the package again
|
1 |
root@ubuntu:~# dpkg-reconfigure phpmyadmin |
after you follow the reinstall steps it will setup the missing sql files for pma tables
MySQL check if there is a relation between rows before deleting it it will raise an error can’t delete or update a parent row we need to till mysql to stop this check
|
1 |
SET FOREIGN_KEY_CHECKS = 0 |
to reactivate it
|
1 |
SET FOREIGN_KEY_CHECKS =1 |
enjoy
we do create many databases every day and i love UTF-8 data formate so i decided to make something simple and save my time here is the syntax to create a database called unixawy in utf8
|
1 |
CREATE DATABASE `unixawy` CHARACTER SET utf8 COLLATE utf8_general_ci; |
to add a user for unixawy with password unixawysecret
|
1 2 |
GRANT ALL ON `test1`.* TO 'unixawy'@'localhost' IDENTIFIED BY 'unixawysecret'; FLUSH PRIVILEGES; |
also, i made a simple script to save my […]
we all hate this ERROR 1045 (28000): the problem starts with “you can’t access and u will not be able to change the MySQL/MariaDB password while the service is running u have to disable it and run mysqld_safe which will allow u to update the user table inside MySQL database with no password then u will […]