"shell>" refers to the command prompt, in a console window (or “DOS window” if you are using MS).
I suggest you google "mysql install guide". If you reply to this post, include the version of MySQL you are installing, your platform, the URL of the install guide you are following, and any error messages you are receiving.
Before you can logon to MySQL you'll need to start the MySQL database server. You'll either set this to start automatically when you turn on your PC, or you can type in the command from the command line. The MySQL database server is known as "mysqld" (See the "bin" directory of your MySQL installation).
For you or your application to logon to the MySQL database server once its started you need a uername and password. I think the "root" username is available automatically after install, as is the database name "test". From the command line you might type in something like "mysql test -u root".
You should create a username for your MySQL database after install instead of using "root" all the time.
I have everything setup for the user and everything, but the problem is that the forums come up with a error message that says it cant connect to the database, yet i checked all the passwords and everything and it should work.
I also tried resotoring the .sql file using mysql admin and it always stops at like 25% and says complete but i know its not complete... why does it do that? should i use shell> instead? whats the commanbd for it lets say if my .sql file was called db.sql and is ion the c:\ directory.
I suggest you try the phpBB Support forum within the community section of phpbb.com (http://www.phpbb.com/phpBB/), as the clarification of your issue shows that it is beyond the scope of this MySQL forum.
In MySQL Version 4.1, the MySQL developers upgraded the process used to authenticate users. The password hash used in authentication was increased from 16 to 41 bytes, and the hashes were made more secure.
One side effect of this is that versions of MySQL clients older than version 4.1 cannot talk to a version 4.1 server, because old clients will not be able to give the proper password hashes.
There are two ways to deal with this. The first way is to upgrade your client library as the error message suggests. This is a good idea because you will then be using more secure authentication and reaping the benefits of newer client libraries. PHP users should note that only the MySQLi library uses a new client library.
The second way is to force the 4.1 server to use the older authentication protocols. This can either be done on a per-account or server-wide basis.
To configure a single account to use the old protocols, set the password for the account using a 16 byte hash:
mysql> SET PASSWORD FOR ’some_user’@’some_host’ = OLD_PASSWORD(’mypass’);
When MySQL detects an 16 byte hash, it will authenticate the account using the older password hasing system and older client applications will be able to connect.
To configure MySQL to use the older authentication scheme on a server-wide level, add old-passwords as an option in your configuration file under the [mysqld] section. This will cause the server to set all passwords using 16 byte hashes, which will force the older authentication scheme. Any existing 41 byte passwords will need to be reset in 16 bytes using the SET PASSWORD syntax described above.