Posts Tagged ‘Mysql’

How to convert Mysql Database to SQLite database?

I have found a simple way to convert the Mysql Database into SQLite database. Following are the steps: Open PhpMyadmin on your browser. (eg. http://localhost:8888/phpmyadmin) Select database and click on Export. Make sure SQL is selected as format and click go. Make a copy of the mysqlcode and store in a file db.txt. Download DB Browser for SQLite from sqlitebrowser.org . Create new Database and create table. Navigate to Execute SQL ... Full story

How to solve PHP Warning: mysqli_connect(): (HY000/2002): Connection refused problem?

The default port on MAMP for mysql is 8889, but the port that php expects to use for mysql is 3306. So you need to change it. Open MAMP, go to Preferences and Ports and change the MAMP mysql port to 3306, then click ok. Then mysql server will be restarted by MAMP if not then restart it manually. Now the connection should be successful ... Full story

How to solve MySql not starting in MAMP problem?

In mac if you have ever encountered a problem that MySQL suddenly stopped working then i have a solution to your problem. I have recently encountered this problem in my Mac OS Sierra. Apache server is working but mysql is not. The solution is to navigate to the mysql folder, in my case its, /Applications/MAMP/db/mysql56/ and remove all the files except ... Full story
Copyright © 2024 Programmer to Programmer- A website for web programming and mobile application programming tutorials.
Wordpress themes