I have recently Installed laragon 4.0.15 on windows 10 and when i start the servers Apache works fine but for MySQL i get this error message saying MySQL can't start reason Can't create test file C:\laragon\data\mysql???.lower-test,
Now What's causing this error???
I've set full permission to C:\laragon Folder It still doesn't work, then i completely removed it and installed it again on (D:) Drive Still doesn't seem to work.....
I recently installed Laragon and updated php to 7.VC15 x64 TS and updated MySQL to 8.0.18 winx64 However MySQL fails to start. The error log shows the following:
2019-10-25T19:25:57.983319Z 0 [ERROR] [MY-010735] [Server] Could not open the mysql.plugin table. Please perform the MySQL upgrade procedure.
2019-10-25T19:25:58.535346Z 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2019-10-25T19:25:58.924966Z 0 [Warning] [MY-010015] [Repl] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2019-10-25T19:25:59.026855Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2019-10-25T19:25:59.031943Z 0 [Warning] [MY-010441] [Server] Failed to open optimizer cost constant tables
2019-10-25T19:25:59.033424Z 0 [ERROR] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-001146 - Table 'mysql.component' doesn't exist
2019-10-25T19:25:59.035749Z 0 [Warning] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-003543 - The mysql.component table is missing or has an incorrect definition.
2019-10-25T19:25:59.039508Z 0 [ERROR] [MY-010326] [Server] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
2019-10-25T19:25:59.041000Z 0 [ERROR] [MY-010952] [Server] The privilege system failed to initialize correctly. For complete instructions on how to upgrade MySQL to a new version please see the 'Upgrading MySQL' section from the MySQL manual.
2019-10-25T19:25:59.047275Z 0 [ERROR] [MY-010119] [Server] Aborting
2019-10-25T19:26:00.287089Z 0 [System] [MY-010910] [Server] C:\laragon\bin\mysql\mysql-8.0.18-winx64\bin\mysqld: Shutdown complete (mysqld 8.0.18) MySQL Community Server - GPL.
I thought that I should be able to easily switch between MySQL/MariaDB versions. Apparently I was wrong.
i have recently installed laragon on my machine(windows 10) and found out that mysql 5.7 is not compatible so i removed it and added another version 5.6.46 and after that it says Service MySQL cannot start reason Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files.Consider setting it to a valid, non-empty path.
alson can't create mysql test file is an error on other mysql versions...?
Hello people. I hope you are all good, I discovered the laragon recently and brother, this is going to take the place of xammp quickly, is a very, very very good server.
I want help with something, I have a local network, and I'm using laragon to host sites that will only be accessible to anyone on the network, but I can only access the site through the ip address of the machine where is installed argon, I happen to not want it to be ip, I want it to be a domain name just like the localtunnel program but with a custom url.
I researched some programs like ngrok, and if paying for this program puts my site online I do not want it, I want it to be accessed only on the local network but with a domain name without ip
In production it works (changing .test to .com), but in the localhost, no one of the links work (css, js, nothing). In view-source I see something like: <link rel="stylesheet" href="http://site.test/assets/bootstrap/css/bootstrap.css">, and if I click on it, it give me the DNS_PROBE_FINISHED_NXDOMAIN message.
Quick q when I use the Menu > www > share > project_name It says thats it's working, but I noticed that it didn't automatically change the auto hosts file. I had to rename it and remove the auto. part from the file name, for the ngrok hostname to be added automatically.
is it a bug? It doesn't seem automatic.
Also where do I add my .yml file to use my login for an unlimited time domain? All my shares have a 7 hour limit. after creating an account it saved a file to C:/users/paulka/.ngrok2/ngrok.yml and if I manually setup ngrok it works, but not when using the auto setup.
I use codeigniter 3.1.9 to do project. But there is a database problem. I can not completely turn off sql mode only_full_group_by. I used phpmyadmin to stop but after every reboot laragon, only_full_group_by mode is automatically turned on.
"Error Number: 1055
Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'bigproject.site_log.access_date' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by"
Though i installed it easily,
i cannot manage to get Grav (the best flat file CMS) to be installed flawlessly.
Following https://learn.getgrav.org/16/basics/installation (using either composer or git) I get an endless stack of error ("Class not found" .... "Unkown character ' '" etc...). I have installed Grav on several dev platforms (XAMPP, WAMP, easyphp ) or prod (Centos, Debian) without facing any single issue.
Has anybody got it working ?
Any lead / help appreciated.