Oprettelse af database i Mysql 4.1.7
Jeg har instaleret Mysql 4.1.7 på en maskine, den skal bruges til en mail server, men da jeg er på meget bar bund ang. Mysql, og da der er ændret noget i forhold til den manual jeg har til min mail server, så har jeg et lille problem med at få oprettet den database jeg skal bruge.Hvordan opretter jeg en db via den feature der hedder "Command Line Client"
Jeg lægger lige det fra manualen til en ældre version med, så i kan se hvad det er jeg skal have op og køre.
In our example we will assume that you decide to replace the embedded database with MySQL 4.0.12 or later, running on localhost, and accepting connections on the default port (3306). Open the mysql console: c:\mysql\bin\mysql --user=root mysql (Linux and Unix: adjust the path to your installation) In the console, type or copy&paste (to paste, simply right-click with the mouse in the console window) the following commands: create database desknow; grant all privileges on desknow.* to desknowserver@localhost identified by 'password'; grant all privileges on desknow.* to desknowserver@'%' identified by 'password'; \u desknow (we recommend choosing a password other than ‘password’) Note: MySQL has also a free and very good graphical console, available at http://www.mysql.com/products/mysqlcc/index.html . We recommend using the command line, however, since copy&paste is easier.
DeskNow - Administration and Configuration
Important: MySQL 4.0 does not support UNICODE. If you want to use a non-Latin character set for your data and emails, make sure to configure MySQL to support that characterset, or choose a different database engine. See the MySQL documentation for more information. According to the documentation provided with your DBMS, execute the database creation SQL script within the created database. The script will create all the tables and indexes necessary. In the mysql console (left at where you were at the previous step), type the following command: \. c:\Program Files\DeskNow\sql\desknow_mysql4.sql (Linux and Unix: the command is: \. /var/desknow/sql/desknow_mysql4.sql ) Note the first two characters are a backslash and a dot. Adjust the path for your installation. To exit the mysql console: \q 6.2.2 Installation of the JDBC drivers DeskNow needs appropriate JDBC drivers to connect to your database. Every major database system has JDBC drivers that can be used, and often there are many versions provided by different vendors. Free JDBC drivers for MySQL are available at http://www.mysql.com/products/connector-j/index.html JDBC drivers usually come as one or more .jar files. To install your driver into DeskNow, you just need to copy the .jar files into the “lib” directory of desknowdata. If you used the Windows installer to install DeskNow, this directory is usually C:\desknowdata\lib. If you used the Unix/Linux installation, this directory is /var/desknowdata/lib . Note: users upgrading from older versions may not have this directory. You can create it manually. Depending on the version of Connector-J that you downloaded, you should find a file called mysql-connector-java-3.0.8-stable-bin.jar or similar. Copy it to the lib directory of desknowdata
