[Solved] "Installation" with Xampp

[andrea75]

I would use a software, "Gazie" on my computer;
for the installation:
- The creation and population of the database can be done using phpMyAdmin or directly in the console:
# cd gazie/setup
# mysqladmin create gazie
# cat install_x.x.x.sql | mysql gazie

I installed the latest version of XAMPP on an Ubuntu-based distribution; to start Apache, Mysql, Proftpd:
# sudo /opt/lampp/lampp start

phpmyadmin is installed, "localhost/phpmyadmin" by browser is available and there are no errors in evidence ...

I copied the folder of interest, "gazie" in the document root, /opt/lampp/htdocs;
to create the database:
# mysqladmin create gazie
The program 'mysqladmin' can be found in the Following packages: * mysql - client - 5.5 * mariadb * mysql - client - 5.5 client - 5.6 * percona - XtraDB - cluster - client - 5.5 Try: apt- get install < selected package>

There is a configuration problem, or do I really have to install another package ?

thanks in advance

[Nobbie]

to create the database:
# mysqladmin create gazie
The program 'mysqladmin' can be found in the Following packages: * mysql - client - 5.5 * mariadb * mysql - client - 5.5 client - 5.6 * percona - XtraDB - cluster - client - 5.5 Try: apt- get install < selected package>

There is a configuration problem, or do I really have to install another package ?

Neither nor, you have learn basic linux skills. You cannot simply apply a program name (here: mysqladmin) without full pathname, if the PATH does not point to it. "mysqladadmin" from Xampp is located at /opt/lampp/bin and that is not included in your PATH environment, therefore you must apply the full pathname instead:

Code: Select all

# /opt/lampp/bin/mysqladmin create gazie

As already said, this is very very basic linux skills, it might be usefull to go for some linux tutorials.

[andrea75]

It works, thanks !

New difficulty.
http://localhost/gazie, returns:
"Access forbidden!
You don't have permission to access the requested directory. There is either no index document or the directory is read-protected.
If you think this is a server error, please contact the webmaster.
Error 403
localhost
Apache/2.4.18 (Unix) OpenSSL/1.0.2f PHP/7.0.3 mod_perl/2.0.8-dev Perl/v5.16.3 "

(chmod gazie: 700 )
http://localhost/phpmyadmin/ -> gazie -> Privileges
Users having access to "gazie" :
User name Host name Type Privileges Grant Action
root 127.0.0.1 global ALL PRIVILEGES Yes Edit privileges
root ::1 global ALL PRIVILEGES Yes Edit privileges
root localhost global ALL PRIVILEGES Yes Edit privileges
Edit privileges -> Database-specific privileges is empty !
Have I to add privileges on the database "gazie", or to add a new user account ?

Thanks in advance

[andrea75]

chmod gazie 777

gconfig.php:
$Host = "localhost";
$Database = "gazie";
$User = "root";
$Password = "*******"; ( my password, now not empty )

It works !

[WilliL]

chmod gazie 777

This means everyone has permission to your database
I don't think that this is the idea of the permisson control of linux!