Start MySQL on console.

Alles, was MariaDB und MySQL betrifft, kann hier besprochen werden.

Start MySQL on console.

Postby Faryshta » 14. July 2008 22:53

Hi, I can't find a command to start MySQL on the console, I tried to find the executable on the carpets but I wasn't lucky.

Or is there any command on XAMPP to administrate my databases using console?

UPDATE; PROBLEM SOLVED.

The executable was on the bin/ folder (complete name for Linux is /opt/lampp/bin/ ). To start using the command line of MySQL, just to place in that folder and type in shell.

./mysql -p<password>

Where <password> is your personal password with no spaces. Then you can see the databases and tables.
Last edited by Faryshta on 14. July 2008 23:59, edited 1 time in total.
Faryshta
 
Posts: 4
Joined: 14. July 2008 20:19

Postby Wiedmann » 14. July 2008 22:56

The MySQL Command-Line Tool is called "mysql":
http://dev.mysql.com/doc/refman/5.0/en/mysql.html
Wiedmann
AF Moderator
 
Posts: 17102
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Not what I mean.

Postby Faryshta » 14. July 2008 23:16

Thanks for the answer but if I haved install MySQL using apt-get, write mysql in the shell would work (my S.O. is Ubuntu) but I use the MySQL which comes with XAMPP and I was asking a way to see the information the user will save on my pages using the shell.

I was thinking something like this on some of the folders of /opt/lampp.

./mysql

And then start the command line of mysql. Also I was thinking something like.

/opt/lampp/lampp mysql

With the same expected result.

AGAIN THANKS FOR YOUR ANSWER :-D
Faryshta
 
Posts: 4
Joined: 14. July 2008 20:19

Postby Wiedmann » 14. July 2008 23:41

I was thinking something like this on some of the folders of /opt/lampp.
./mysql

Binaries are usual installed in a bin dir. So I guess it's in /opt/lampp/bin.

(Sorry, don't use Linux)
Wiedmann
AF Moderator
 
Posts: 17102
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

IT WORK!

Postby Faryshta » 14. July 2008 23:54

Thanks it totally work.

Now I can change the subject to SOLVED.

Thanks again. :D
Faryshta
 
Posts: 4
Joined: 14. July 2008 20:19


Return to MariaDB - MySQL

Who is online

Users browsing this forum: No registered users and 10 guests