The answer to that question is largely dependent on the host OS and version of MySQL that you are running. However I'm pretty sure all versions have a CLI included.
on my windows server its Start -> All Programs -> MySQL -> MySQL Server 5.1 -> MySQL Command ling client
on my Linux box I access it via terminal. Something like:
$ mysql -u root -p
Regardless of which way you get here its essentially the same from this point forward.
First thing we need to do is create the Database that OSTicket is going to live in.
mysql> CREATE DATABASE tickets;
note: you may and should change "tickets" above to whatever you want it to be.
Next we need to create a user and give it access to the Database we just made.
mysql> GRANT ALL ON tickets.* TO username@hostname IDENTIFIED BY 'password';
note: once again change "tickets" above to match whatever you used in the step before this.
note: change "username" to whatever you want the username to be.
note: change "hostname" to the FQDN of the machine the scripts reside on. (in a windows environment you can utilize the hostname/netBIOS name.)
note: make sure you change "password" to something real.
Lastly run the following command:
mysql> FLUSH PRIVILEGES;
This will force MySQL to reload Privileges from the grants table in MySQL.
Once you have done all this, you can go and run the installer for OSTicket. You will utilize what we set above (which if you didn't change anything ) would be:
MySQL servername: hostname
MySQL database name: tickets
MySQL username: username
MySQL password: password
Good luck.