PDA

Archiv verlassen und diese Seite im Standarddesign anzeigen : datenbank anlegen



zwelch
30.12.02, 11:17
bitte nich schimpfen bin absoluter n00b :) gesucht hab ich auch schon aber nicht so recht das gefunden was ich suchte ...

also hab suse 8 pro
das is drauch apache incl. mysql und php und phpmy admin ...
leider kann ich ja diese "hauptdatenbanken" nicht im phpmyadmin anlegen also muss ich das ja in der konsole machen .. nur wie ...

thx

ChengFU
30.12.02, 12:10
Hallo,

welche "Hauptdatenbanken" willst du denn anlegen?
Die einzige Datenbank, die der Mysql selbst braucht ist "mysql" und sollte beim ersten Start des Servers erzeugt werden.
Alle weiteren Datenbanken kannst du per "CREATE DATABASE neue_datenbank;" erzeugen.

Gruss,
Mario Witte

zwelch
30.12.02, 12:23
ich raff das nicht ....



linux:~ # mysql CREATE DATABASE test;
mysql Ver 11.15 Distrib 3.23.48, for suse-linux (i686)
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Usage: mysql [OPTIONS] [database]

-?, --help Display this help and exit.
-A, --no-auto-rehash No automatic rehashing. One has to use 'rehash' to
get table and field completion. This gives a quicker
start of mysql and disables rehashing on reconnect.
-B, --batch Print results with a tab as separator, each row on
a new line. Doesn't use history file.
--character-sets-dir=...
Directory where character sets are located.
-C, --compress Use compression in server/client protocol.
-D, --database=.. Database to use.
--default-character-set=...
Set the default character set.
-e, --execute=... Execute command and quit. (Output like with --batch)
-E, --vertical Print the output of a query (rows) vertically.
-f, --force Continue even if we get an sql error.
-g, --no-named-commands
Named commands are disabled. Use \* form only, or
use named commands only in the beginning of a line
ending with a semicolon (;) Since version 10.9 the
client now starts with this option ENABLED by
default! Disable with '-G'. Long format commands
still work from the first line.
-G, --enable-named-commands
Named commands are enabled. Opposite to -g.
-i, --ignore-space Ignore space after function names.
-h, --host=... Connect to host.
-H, --html Produce HTML output.
-L, --skip-line-numbers
Don't write line number for errors.
--no-pager Disable pager and print to stdout. See interactive
help (\h) also.
--no-tee Disable outfile. See interactive help (\h) also.
-n, --unbuffered Flush buffer after each query.
-N, --skip-column-names
Don't write column names in results.
-O, --set-variable var=option
Give a variable an value. --help lists variables.
-o, --one-database Only update the default database. This is useful
for skipping updates to other database in the update
log.
--pager[=...] Pager to use to display results. If you don't supply
an option the default pager is taken from your ENV
variable PAGER (less).
Valid pagers are less, more, cat [> filename], etc.
See interactive help (\h) also. This option does
not work in batch mode.
-p[password], --password[=...]
Password to use when connecting to server
If password is not given it's asked from the tty.

-P, --port=... Port number to use for connection.
-q, --quick Don't cache result, print it row by row. This may
slow down the server if the output is suspended.
Doesn't use history file.
-r, --raw Write fields without conversion. Used with --batch
-s, --silent Be more silent.
-S --socket=... Socket file to use for connection.
-t, --table Output in table format.
-T, --debug-info Print some debug info at exit.
--tee=... Append everything into outfile. See interactive help
(\h) also. Does not work in batch mode.
-u, --user=# User for login if not current user.
-U, --safe-updates[=#], --i-am-a-dummy[=#]
Only allow UPDATE and DELETE that uses keys.
-v, --verbose Write more. (-v -v -v gives the table output format)
-V, --version Output version information and exit.
-w, --wait Wait and retry if connection is down.

Default options are read from the following files in the given order:
/etc/my.cnf /var/lib/mysql/my.cnf ~/.my.cnf
The following groups are read: mysql client
The following options may be given as the first argument:
--print-defaults Print the program argument list and exit
--no-defaults Don't read default options from any options file
--defaults-file=# Only read default options from the given file #
--defaults-extra-file=# Read this file after the global files are read

Possible variables for option --set-variable (-O) are:
connect_timeout current value: 0
max_allowed_packet current value: 16777216
net_buffer_length current value: 16384
select_limit current value: 1000
max_join_size current value: 1000000
linux:~ # n't use history file.
> -r, --raw Write fields without conversion. Used with --batch
> -s, --silent Be more silent.
> -S --socket=... Socket file to use for connection.
> -t, --table Output in table format.
> -T, --debug-info Print some debug info at exit.
> --tee=... Append everythin't use history file.
bash: nt use history file.
-r, --raw Write fields without conversion. Used with --batch
-s, --silent Be more silent.
-S --socket=... Socket file to use for connection.
-t, --table Output in table format.
-T, --debug-info Print some debug info at exit.
--tee=... Append everythint: command not found
linux:~ # -r, --raw Write fields without conversion. Used with --batch
bash: -r,: command not found
-S --socket=... Socket file to use for connection.
linux:~ # -s, --silent Be more silent.
bash: -s,: command not found
-T, --debug-info Print some debug info at exit.
linux:~ # -S --socket=... Socket file to use for connection.
bash: -S: command not found
linux:~ # -t, --table Output in table format.
bash: -t,: command not found
linux:~ # -T, --debug-info Print some debug info at exit.
bash: -T,: command not found
linux:~ # --tee=... Append everythi
linux:~ #


irgendwas haut nciht hin oder ich mach alles falsch :)

bernie
30.12.02, 12:31
Hi,

mach mal

mysql -uroot -p

dann bekommst du eine Eingabeaufforderung wo du deine SQL-Statements absetzen kannst.

Ciao, Bernie

zwelch
30.12.02, 12:53
hmpf :)

Last login: Mon Dec 30 03:33:25 2002 from 192.168.0.2
Have a lot of fun...
linux:~ # mysql -uroot -p
Enter password:
ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)
linux:~ #

geht nich :) .. hab auch kein pw festgelegt ...

ChengFU
30.12.02, 13:17
Hallo,

Wenn du kein Passwort hast solltes es ein "mysql -uroot" tun. Evtl. klappts auch wenn du nur "mysql" eingibst.

Gruss, Mario Witte

zwelch
30.12.02, 13:46
kewl thx jetzt gehts

linux:~ # mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 64 to server version: 3.23.48-log

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

mysql> CREATE DATABASE test;
Query OK, 1 row affected (0.03 sec)

mysql>


und wie kann ich die datenbank jetzt mir nem passwort schützen ?

bernie
30.12.02, 14:34
in den Tables

mysql.user und mysql.db

Ciao, Bernie

zwelch
30.12.02, 15:03
eins noch :) wie loesch ich die createte db wieder :)

Tocotac
30.12.02, 15:13
Original geschrieben von zwelch
eins noch :) wie loesch ich die createte db wieder :)

ich glaube mit drop
aber das sollte alles phpmyadmin können. es gibt auch noch andere mysql-frontends...
(windows: mysql-front)

bernie
30.12.02, 15:27
drop test;

Ciao, Bernie

ChengFU
30.12.02, 15:33
Wäre nicht "drop database test" korrekter?

Gruss, Mario Witte

bernie
30.12.02, 15:48
da war ich mir jetzt nicht sicher, bei create weiss ich, dass das database rein gehört.

Ciao, Bernie

ChengFU
30.12.02, 16:15
@bernie:

Ok, ich behaupte es gehört da hin(wg. Verwechslung mit "drop table xy") Habe zwar gerade eine Konsole vor mir, aber wenn ich da jetzt ne database droppe verhaut mich mein Cheffe :-)

Gruss,
CF

zwelch
30.12.02, 16:29
ach was ... sagste es war im sinne der forschung :D