Page 1 of 1

New Xampp user

PostPosted: 23. February 2021 13:25
by Ape
Good day,
Very simple question. New user. So every time I turn on my computer, should I go to the control panel and start apache and sql? And when I'm done for the day, click on stop and quit the control panel? Thank you.

Re: New Xampp user

PostPosted: 23. February 2021 13:54
by Altrea
Hi,

It is always a good idea to only start a program if you need it, and stop it after that.

Re: New Xampp user

PostPosted: 23. February 2021 15:25
by Ape
Thank you.
My Apache and MySql is green on the panel. Had to change listen on conf. But now when I click on Admin it goes to IIS windows. I already deleted IIS and restarted. Please help. Thanks

Re: New Xampp user

PostPosted: 23. February 2021 15:32
by Altrea
If you don't need IIS, don't change the Apache ports.
Read this: viewtopic.php?f=22&t=69784&p=239058#p239059

If you at all need to change the Apache ports, do it the right way and tell the control panel too what the new ports are

Re: New Xampp user

PostPosted: 23. February 2021 15:49
by Ape
It doesn't start if its 80 so I changed it to 8090.
Now I tried this: http://localhost:8090/myphpadmin/
It gave me this: Not Found

The requested URL was not found on this server.

Thank you for your time.

Re: New Xampp user

PostPosted: 23. February 2021 16:16
by Ape
Thank you. viewtopic.php?f=22&t=69784&p=239058#p239059 instruction works.

http://localhost:8090/phpmyadmin/ FINALLY WORKED!!!!!

Re: New Xampp user

PostPosted: 12. March 2021 21:10
by Ape
Hi :wink:

On SQL tab, I entered todays date March 12, 2021 and I got an error #1064. It says refer to MariaDB version. How should I type the date?

I was also trying to find MySQL on command prompt but couldnt locate it. I found another SQL server VSS Writer but wasn't sure if its the same one.
What I was trying to do is check the database I created on command line.
Thank you.

Re: New Xampp user

PostPosted: 12. March 2021 23:23
by Altrea
Hi,

Ape wrote:On SQL tab, I entered todays date March 12, 2021

What does that mean?

Ape wrote:I got an error #1064. It says refer to MariaDB version.

Error 1064 means you have an error in your SQL syntax. You didn't show us your SQL Syntax.
Besides from this it is a very poor error report you tried here.

Ape wrote:How should I type the date?

https://mariadb.com/kb/en/date-and-time-data-types/

Ape wrote:I was also trying to find MySQL on command prompt but couldnt locate it.

There is no specific command prompt. MariaDB provides a CLI (command line interface) which can be used by the default windows command line cmd.exe
To use the Windows command line, you need to navigate first to the folder \xampp\mysql\bin\
The CLI is accessed by program mysql, so the usage: mysql [OPTIONS] [DATABADE]
Vor getting an impression of the commands type mysql --help

Instead of using the windows cmd you can use the XAMPP Shell too by clicking the Shell button in the XAMPP control panel. This opens the command line too, but sets some additional paths and settings so you can use the CLI without navigating to \xampp\mysql\bin\

Re: New Xampp user

PostPosted: 15. March 2021 16:29
by Ape
Hi,

I'm trying to edit privileges for the mySql password. I tried on clicking on edit privileges tabs and I got some errors.

Like, Warning in .\libraries\classes\Dbi\DbiMysqli.php#199
mysqli::query(): (HY000/1030): Got error 176 "Read page with wrong checksum" from storage engine Aria.

and
Error
SQL query:
SELECT * FROM `mysql`.`db` WHERE `User` = 'pma' AND `Host` = 'localhost' ORDER BY `Db` ASC

Should I do something about it or ignore it? Thank you.

Re: Nuovo utente Xampp

PostPosted: 02. April 2021 15:47
by lusta
Hi, I'm a beginner, I need help to get into the world of xampp; from installation to operation. Thanks

Re: New Xampp user

PostPosted: 03. April 2021 10:21
by Nobbie
Enter "Xampp Tutorial" into Google.