Connecting MySQL with PHP

[Aleksey]

A question about MySQL beginners course, part of connecting mysql with php, the video was very quickly and i didnt understand well.

 

1) Is there any simple way to connect a user to a database without such apps such cPanel? (from MyAdmin)

 

2)You told - "I am just using cPanel to connect a user with a database". Is there some free cPanel alternative that would work good on both mac and windows operating systems? For example i found some alternatives but on the download page i didnt see macos supported.

[administrator]

Hi,

Typically CPANEL is included with so many hosting companies. So I would just find a host that has that. 

There are several ways to connect to MySQL besides CPANEL. You could connect via command line using SSH. You could use a third party program that works with MySQL ... they almost always allow for remote MySQL connections. Here are the options:

Any client for MySQL should work equally well for derived products, such as MySQL Enterprise, Percona Server, MariaDB, etc.

Free Clients

• MySQL Workbench (Mac, Windows, Linux), Free, open-source
• Sequel Pro (Mac), Free, open-source
• HeidiSQL (Windows; claims it can run on Mac or Linux using WINE emulator), Free, donation encouraged
• phpMyAdmin (web app), Free, open-source
• Toad for MySQL (Windows), Free
• MySQL-Front (Windows), Free, open-source
• Neor Profile SQL (Mac, Windows, Linux), Free

Commercial Clients with a Free Option

• DBVisualizer (Mac, Windows, Linux), Free version or Pro (Purchase a DbVisualizer Pro License)
• dbForge Studio for MySQL (Windows), Free version (Express) or Standard or Pro (Ordering dbForge Studio for MySQL)
• Valentina Studio (Mac, Windows, Linux, iOS), free or Pro (product category)
• SQLPro for MySQL (macOS, iOS), free (unlimited with nag) trial. iPhone/iPad version is free for a single connection.
• SQLyog Community version (Windows)

https://www.quora.com/What-is-the-best-MySQL-client-for-Mac-OS-X-or-Windows

 

[Aleksey]

Thanks Stef, i solve the problem with MyAdmin!

I didnt know that its possible to connect user with database just using MyAdmin, in MySQL video tutorial you did it with cPanel and talked about third party apps and command line.