There already IS a root user (with no password) in every MySQL installation by default. Think about if for a minute and you will see why.
XAMPP/LAMPP (once installed) is 'ready to work'
I recommend you NOT try to use the MySQL CLI (unless you understand Linux pretty well and can grok the differences between XAMPP and a standard LAMP stack). Things are in 'different places' and have 'different owners'. So 'standard' Linux/LAMP commands may get ambiguous results. That is the source of your issue. That mysql command did not know where to find MySQL, that's why it wanted to install the client.
the mysql executable is in /opt/lampp/bin. SOOOO, just like LAMPP (/opt/lampp/lampp ...) SO you should start the MySQL monitor with commands like so:
- Code: Select all
/opt/lampp/bin/mysql --user root --password
you will be prompted for your password.
that will start the MySQL monitor and you'll get the mysql> prompt
- Code: Select all
[root@localhost jonb]# /opt/lampp/bin/mysql --user root --password
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 28
Server version: 5.5.8 Source distribution
Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> exit
Beyond that, you will want to learn a dizzying array of command parameters that may or may not work in any given situation (not my job on that, I didn't write it).
You should look at the XAMPP/LAMPP Linux FAQ's if you haven't (down toward the bottom).
http://www.apachefriends.org/en/xampp-linux.htmlIf you have given the MySQL 'root' a password, you will need to fix config.inc.php for phpMyAdmin.
If it (this install) doesn't work out, the EASIEST thing to do is use the 'remove' commands listed on that page and just start fresh.
Good Luck