Basic Commands of Mysql to create a database, create a table, create a user with password and give privilages to the table. These commands can be used in a Mariadb terminal without modification. Because Mariadb is compatible with Mysql also. Mysql command line is used for managing linux servers in remote hosting. These commands are …
[Mysql Basic] Create Database Username Password Tables Read More »
Now a days phpmyadmin is using widly for managing mysql databases in almost all hosting environments.Think of an alternative ? Chive is an alternative tool for PhpMyadmin, it is a webbased MySQL database management tool. The web-based user interface supports most of the common operations needed by software developers and database admins in MySQL(databases, tables, …
Web Based Mysql Administration Tool – Chive Released Read More »
You can recover MySQL database server password with following five easy steps. Step # 1: Stop the MySQL server process. Step # 2: Start the MySQL (mysqld) server/daemon process with the –skip-grant-tables option so that it will not prompt for password Step # 3: Connect to mysql server as the root user Step # 4: …
Setting up mysql password is one of the essential tasks. By default root user is MySQL admin account. Please note that the Linux / UNIX login root account for your operating system and MySQL root are different. They are separate and nothing to do with each other (indeed some admin removes root account and setup …