hello, my question it's that everytime i restart my pc, login, in the command prompt i type command mysql, it can't not find the path where the mysql it's located at
(mysql located at /usr/local/mysql/bin) ??
so i type source ~/.bash_profile, then type mysql it work... but i don't like type all that source things. it's way i could set it so it say that way when i restart ??

thanks


here my .bash_profile

# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/bin:/usr/local/mysql/bin
BASH_ENV=$HOME/.bashrc
USERNAME="root"

export USERNAME BASH_ENV PATH

~
~
~
~
~
~
~
~
~
"~/.bash_profile" 15L, 255C

I can't _really_ solve your problem, but:
Might you be running Mandrake?
I believe to have experienced a similar problem with my PS1 variable [command prompt appearance] that would only work if I put the line [PS1=xxx] in my .bashrc file.
Odd, but at least it works.
You could also add a symlink to /usr/local/mysql/bin/mysql somewhere in your /usr/bin or $HOME/bin dirs.

Try putting it in ur .bashrc instead of ur bash_profile. I think that should help! As in add this to your .bashrc

PATH=$PATH:$HOME/bin:/usr/local/mysql/bin
BASH_ENV=$HOME/.bashrc
USERNAME="root"

export USERNAME BASH_ENV PATH