MySql, Leopard and terminal - MySql -u root -p

[majorp]

I have installed mysql on leopard succesfully (i think)

Through CocoaMySql I can connect via root@localhost with no password, create databases etc.

But..... I can't connect through terminal.

when I enter:

>mysql -u root -p

-bash: mysql: command not found

even when i use the full path /usr/local/mysql still the same error.

It's as if the link hasn't been created for mysql?

This is on a fresh install of leopard with nothing else installed.

Any help appreciated.

 

[stomer]

You may have installed the mysql server but not the client. To find out for sure just run:

$ sudo find / -name 'mysql' -print

If you do have the mysql client installed, then the above command will (eventually) tell you where it is.

 

[sord]

Its /usr/local/mysql/bin/mysql, not just /usr/local/mysql

You may want to add it's bin to your PATH too (create/edit your ~/.bash_profile and put:

export PATH="$PATH:/usr/local/mysql/bin"

in it)

 

[majorp]

thanks to you both. seems to be working now

user error...

 

[dni777]

Which version of mySQL for Leopard?

Which version of mySQL will be best for Leopard?

 

[stomer]

Which version of mySQL will be best for Leopard?

I don't think it's a question of what's best for Leopard, as both 4 and 5 will run fine on Leopard, it's more a question of what features you require.

I don't see any reason to run 4 over 5, as version 5 is now stable enough for a production environment and also has a lot more features.
There may be features that you require that are only available in 5.1 and/or 6. Then you need to decide if it's worth running a db that might have stability problems.

 

[abcNoob]

If you log in as Root without a password, you do not type:
mysql -uroot -p

You instead should type:
mysql -uroot

I hope it helps

 

[matttheaviator]

.bash_profile problem

Hi Im using the same setup and have tried to find the .bash_profile file but cant so i tried to create it like the install docs said and it said to save it my home. Is the exact path macHDD/users/myaccount/.bash_profile

also I cant get the mysql databse to start up once i initialised it for the first time

Any ideas

very frustrated.

Thanks for any help with this problem(s)

matt

 

[angelwatt]

Is the exact path macHDD/users/myaccount/.bash_profile

also I cant get the mysql databse to start up once i initialised it for the first time

Correct on the path. You can also access Home by doing ~/ So you could edit the bash profile by doing:

pico ~/.bash_profile

What program are you using to edit the profile?

As far as the MySQL, what commands are you trying?

 

[harmander]

great help..

Its /usr/local/mysql/bin/mysql, not just /usr/local/mysql

You may want to add it's bin to your PATH too (create/edit your ~/.bash_profile and put:
Code:
export PATH="$PATH:/usr/local/mysql/bin"



thanks allooottt