From: Jethro Cramp <jsc@zoo.co.uk> Date: Thu, 23 Nov 2000 10:00:33 +0000 Message-Id: <00112310003300.00673@zeus> Subject: Creating MySQL database On Wednesday 22 November 2000 11:57 pm, Fred A. Miller wrote:
Jethro, I know this is a dumb question, but since I can't seem to be able to find the answer with the software, I've got to ask. What do I need to create a database for use with the MySQL client that ships with 7.0?
Thanks!
Fred
Dear Fred, There are a couple of ways to do this. If you use mysql client (invoked at the command line with mysql) then to create a new database you: CREATE DATABASE database_name; Note the semi-colon at the end of the statement. The use you log in as will have to have write priveliges on the database. The easiest way to do this is to login to linux as root then start mysql client and create a new user with write priveliges. This is a bit more involved but is included in the documentation. On SuSE 7.0 the documentation is in: file:/usr/share/doc/packages/mysql/html. Another way to work is with kmysql (if you use a GUI that is). This is a KDE1.x app and as I remember is included in the SuSE KDE packages. It works fine under KDE2.0 as well. Good luck -- Regards, Jethro