Category: MySQL

  • Auto commit for MySQL databases

    In corporate database systems, it is generally preferred to build transaction stacks. This allows for having multiple database statements run and be finally committed if everything is ok. In MySQL, auto commit is on by default; which means that every statement is instantly committed. To check the value of auto commit, run the following MySQL…

  • Access to MySQL

    To gain access to MySQL run the following command: mysql -u root -p mysql You will be prompted for the root password. mysqladmin command to change root password If you have never set a root password for MySQL, the server does not require a password at all for connecting as root. To setup root password…