Mysql UPD Download Xampp
Amy Sumler
But at first you have to set/change the MySQL Root password. Start the Apache server and type localhost or 127.0.0.1 in your browser's address bar. If you haven't deleted anything from the htdocs folder the xampp status page appears. Navigate to security settings and change your mysql root password.
3. Checked the service list for mysql.service nothing showed up
4. Tried to access log files in /opt/lampp/var/mysql, tried to access the following files: ib_logfile0, ib_logfile1, aria_log.00000001 with the following command : sudo nano [filename]. What i got was gibberish text.
Just make sure that your mysql is binding to a socket on 0.0.0.0 and you should be able to connect to that socket. I guess the default is for mysql to bind to 127.0.0.1, which, of course, is hard to reach from the outside.
Everyone on your network should then be able to connect that MySQL instance. Of course, that may include people who better shouldn't do that. But as long as there is a password for each mysql user and the instance is not facing the internet, there is not much to worry about.
Now that we have everything needed to recreate the site locally, we can start working with XAMPP. The first step is to copy the files from (C:\Users\##YOURNAME##\Desktop\Backup\) into your XAMPP htdocs folder, inside of a test folder (C:\xampp\htdocs\test\).
Now that we all of our files and database setup, we need to create a virtual domain for the site. Open up C:\xampp\apache\conf\extra\httpd-vhosts.conf. At the bottom of the file add the following code:
Decide where you are going to place the Yii framework code (in xampp/htdocs or elsewhere). Load index.php from yii/requirements. It checks your php.ini file to see if it is configured properly for yii and displays a page showing any problems to correct. You only have to make these corrections once.
In this script, we first establish a connection to the database as we did in the previous example. Then, we create an SQL query to retrieve data from the users table. We use the mysqli_query() function to execute the query and store the result in a variable. Finally, we use the mysqli_fetch_assoc() function to output the data, row by row.
Your Mysql install section is copy/pasted from the ubuntu 18 article. But if you follow your instrctions you will notice there is my mysql-server package and instead is mariadb-server. In 20.04 they changed mysql to mariadb as default, this guide like many other guides around the internet need to be updated.
I have been so stupid to hit go at the bottom after I added a new user, deleting all users including root. I have re-installed xampp twice, tried to change the password via the xampp security, still with no success. xAmpp loads perfect on , phpMyAdmin though shows the following error -
You can delete all your mysql data by deleting the "data" directory in \xampp\mysql (at least that's the path in my installation). The access restrictions are stored in a database named mysql, so when you delete and re-install it you should be back on square 1.
This has nothing to do with any windows administrator privileges - mysql maintains its completely independent access restriction system.