Skip to main content

How to Create New MySQL User | import sql file in mysql | phpmyadmin | xampp

By

This video based on creating a new user and import data using the MySQL database. I've tried to show How to create a new user in the database and give permission. And I've created dummy data and import those data to the MySQL database.

. . . phpMyAdmin is a free and open source administration tool for MySQL and MariaDB. As a portable web application written primarily in PHP, it has become one of the most popular MySQL administration tools, especially for web hosting services. . create a free dummy data for MySQL : https://mockaroo.com/



Comments

Post a Comment

Top Most viewed

How to draw circle, rectangle and triangle by canvas in Android?

By
Hi... friends, welcome to Bit Byte. This video is How to draw circles, rectangles, and triangles by canvas on Android? The Android Canvas provides convenient methods for drawing simple shapes such as circles and rectangles, using drawCircle and drawRect respectively, but beyond these, the majority of shapes require some custom Path logic to draw. Three shapes that I was required to draw were circle, rectangle, and triangle, so I thought I’d share how I accomplished this. And hard copy code is below this link. GitHub - https://github.com/giriArun/AndroidCanvasT1.git
Post a Comment
Read more

Connect to MySQL with PHP in XAMPP or WAMP server || MySQL database connection with PHP

By
This video will discuss how to connect to MySQL with PHP. I'm using PhpMyAdmin and connect MySQL database with PHP using the WAMP server. And you can use this code any php server. . . . WampServer Version 3.1.9 64bit Created by Romain Bourdon (2005) Maintainer / Upgrade to 2.5 by Herve Leclerc Upgrade to 3 by Otomatic (wampserver@otomatic.net) Multi styles for homepage by Jojaba Installer by Inno Setup: http://www.jrsoftware.org/isinfo.php Forum Wampserver: http://forum.wampserver.com/index.php ______________________ Versions used ______________________ Apache 2.4.39 Port 80- PHP 7.2.18 MySQL 5.7.26 Port 3308 PHP 5.6.40 for CLI (Command-Line Interface) CODE:- <?php //DB connection // new mysqli(host, user, password, database name); $connect = new mysqli("localhost:3308", "bit", "bitbyte", "bit_yt"); //Check connection if($connect->connect_error){ echo "Failed to connect to MySQL: ". $connect->connect_error; exit(); } ...
Post a Comment
Read more

AJAX call in jQuery get and post method | ajax call in PHP using jQuery | ajax call with example

By
In this Ajax call video, I'm trying to show how to call Ajax in jQuery using the GET or POST method. And how simple you call Ajax in PHP using jQuery. In this video, I did that with an example. I'm using the GET and POST method, and I called Ajax and got back a return value. AJAX stands for Asynchronous JavaScript and XML. AJAX is a new technique for creating better, faster, and more interactive web applications with the help of XML, HTML, CSS, and Java Script.
Post a Comment
Read more