change account

[redzzzon]

Change to a different account on the command line shell. I do not know how to access to different accounts. The goal is to create .sql files.

thanks tom

[bretticus]

huh????

Oh well, anyways, from a *NIX command prompt, to change user accounts, you use the su user command, which will prompt you for a password unless you are root. I don't have a clue what this has to do with creating SQL files, so I hope my answer is adequate.

[redzzzon]

hi
#########################################

Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5 to server version: 4.0.21-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> user
->
########################################

from here I want to enter into another account on the MYSQL databases server.

I am at the root and want to go another account

Thanks

[bretticus]

ah! nothing to do with PHP I can see. You are in the wrong forum, in the future you'll be better served at MySQL Forums

However, I do know that you can either use the su command to login as another user from the command prompt or you can use the -u switch to login from the CLI as a different user which will have to have credentials setup for user @ for the login to be successful