connecting to phpmyadmin through terminal ??

Problems with the Mac OS X version of XAMPP, questions, comments, and anything related.

connecting to phpmyadmin through terminal ??

Postby rickyspires » 07. January 2010 11:04

hello.

sorry but im having trouble getting into my phpmyadmin through terminal.

i have looked at tones of forum posts but nothing seems to work.

im on mac osx 10.5.8 Leopard
im using xampp 1.7.2

my phpmyadmin is located at /Applications/XAMPP/xamppfiles/phpmyadmin

i tried /Applications/XAMPP/xamppfiles/bin/mysql which got me to mysql but then when i input a command to create a database i got:

mysql> CREATE DATABASE widget_corp;
ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'widget_corp'

all i need to do is login and create databases using terminal.... please help.

many thanks
rick
:?
rickyspires
 
Posts: 2
Joined: 07. January 2010 10:56

Re: connecting to phpmyadmin through terminal ??

Postby rickyspires » 07. January 2010 14:18

hello.

i got it working in the end :)

1 - i reinstalled xampp
2 - logged in to phpmyadmin and set the privilege for root user @ localhost
3 - edited the config.inc.php file
4 - logged in to terminal with command /sudo su
5 - setup my security with /Applications/XAMPP/xamppfiles/xampp security
6 - found my mysql at /Applications/XAMPP/xamppfiles/bin/mysql
7 - typed - mysql> CREATE DATABASE widget_corp;

and it all works :)

FOLLOW THE HELP FILES :)
rickyspires
 
Posts: 2
Joined: 07. January 2010 10:56

Re: connecting to phpmyadmin through terminal ??

Postby AJ613 » 10. January 2010 17:10

Bless you! Bless you! Bless you! I have been struggling with this for weeks! I was trying to use MySQL with Snow Leopard to no avail. Finally I downloaded XAMPP, turned on Apache, MySQL and FTP, typed in /applications/xampp/xamppfiles/bin/mysql from your post. And I saw that beautiful command promp mysql>

Thank you again!
AJ613
 
Posts: 1
Joined: 10. January 2010 16:56

Re: connecting to phpmyadmin through terminal ??

Postby ohforfuckssake » 02. February 2010 15:27

You are positively wonderful. I have installed reinstalled and resorted to illegal substances but still no luck but now..... I am happily creating databases and administering mysql in the Terminal. Such a simple solution to a really annoying problem
Seriously posts like yours are life savers.

Thank you
ohforfuckssake
 
Posts: 5
Joined: 08. March 2009 12:08


Return to XAMPP for Mac OS X

Who is online

Users browsing this forum: No registered users and 2 guests