Newsgroup: it.comp.www.php
Titolo: MySql - Start

Ho appena finito finito di installare EasyPHP.
Ho anche provato il funzionamento del server e del php e tutto sembra
funzionare bene.
EasyPHP dovrebbe anche aver installa il MySql...
Come lo utilizzo? Ovvero.... come lo avvio? Da dos? (ho provato a scrivere
"mysql"). E come creo il mio primo database?
Grazie..

il sapiente ~RicMan~ dice:

c'è una bella cosa su internet chiamata "MANUALE"...
4.12.2 Starting MySQL on Windows 95 or Windows 98
MySQL uses TCP/IP to connect a client to a server. (This will allow any 
machine on your network to connect to your MySQL server.) Because of this, 
you must install TCP/IP on your machine before starting MySQL. You can find 
TCP/IP on your Windows CD-ROM. 
 Note that if you are using an old Win95 release (for example OSR2), it's 
likely that you have an old Winsock package! MySQL requires Winsock 2! You 
can get the newest Winsock from Microsoft. Win98 has as default the new 
Winsock 2 library, so the above doesn't apply for Win98. 
 There are 2 different MySQL servers you can use: 
mysqld 
 Compiled with full debugging and automatic memory allocation checking 
mysqld-opt 
 Optimized for a Pentium processor. 
 Both of the above should work on any Intel processor >= i386. 
 To start the mysqld server, you should start an MS-DOS window and type: 
C:\mysql\bin\mysqld
 This will start mysqld in the background without a window. 
 You can kill the MySQL server by executing: 
C:\mysql\bin\mysqladmin -u root shutdown
 Note that Win95/Win98 don't support creation of named pipes. On 
Win95/Win98, you can only use named pipes to connect to a remote MySQL 
running on an NT server. 
 If mysqld doesn't start, please check whether or not the 
`\mysql\mysql.err' file contains any reason for this. You can also try to 
start it with mysqld --standalone; In this case you may get some useful 
information on the screen that may help solve this. 
 The last option is to start mysqld with --debug. In this case mysqld will 
write a log file in `\mysqld.trace' that should contain the reason why 
mysqld doesn't start. If you make a bug report about this, please only send 
the lines to the mailing list where something seems to go wrong! 
4.12.3 Starting MySQL on NT or Windows 2000
 The Win95/Win98 section also applies to MySQL on NT/Win2000, with the 
following differences: 
 To get MySQL to work with TCP/IP on NT, you must install service pack 3 
(or newer)! 
 Note that everything in the following that applies for NT also applies for 
Win2000! 
 For NT/Win2000, the server name is mysqld-nt. Normally you should install 
MySQL as a service on NT/Win2000: 
C:\mysql\bin\mysqld-nt --install
 (You could use the mysqld or mysqld-opt servers on NT, but those cannot be 
started as a service or use named pipes.) 
 You can start and stop the MySQL service with: 
NET START mysql
NET STOP mysql
 Note that in this case you can't use any other options for mysqld-nt! 
 You can also run mysqld-nt as a stand-alone program on NT if you need to 
start mysqld-nt with any options! If you start mysqld-nt without options on 
NT, mysqld-nt tries to starts itself as a service with the default service 
options. If you have stopped mysqld-nt, you have to start it with NET START 
mysql. 
 The service is installed with the name MySql. Once installed, it must be 
started using the Services Control Manager (SCM) Utility (found in Control 
Panel) or by using the NET START MySQL command. If any options are desired, 
they must be specified as "Startup parameters" in the SCM utility before 
you start the MySQL service. Once running, mysqld-nt can be stopped using 
mysqladmin or from the SCM utility or by using the command NET STOP MySQL. 
If you use SCM to stop mysqld-nt, there is a strange message from SCM about 
mysqld shutdown normally. When run as a service, mysqld-nt has no access to 
a console and so no messages can be seen. 
 On NT you can get the following service error messages: 
Permission Denied 
 Means that it cannot find mysqld-nt.exe. 
Cannot Register 
 Means that the path is incorrect. 
 If you have problems installing mysqld-nt as a service, try starting it 
with the full path: 
C:\mysql\bin\mysqld-nt --install
 If this doesn't work, you can get mysqld-nt to start properly by fixing 
the path in the registry! 
 If you don't want to start mysqld-nt as a service, you can start it as 
follows: 
C:\mysql\bin\mysqld-nt --standalone
 or 
C:\mysql\bin\mysqld --standalone --debug
 The last version gives you a debug trace in `C:\mysqld.trace'. 
-- 
Punkarruso
mail:punkarruso chiocchiolona despammed punto com
pubblicità progresso:
http://www.nist.gov/dads/

Se fai partire EasyPhp, sarà lui a ad avviare MySql ed Apache.
Per amministrare, creare etcc database sotto MySql ti consiglio di cercare e
scaricare PhPMyAdmin
Ciao
"~RicMan~" <ale...@XXiol.it> ha scritto nel messaggio
news:al211l$ua$1...@fe1.cs.interbusiness.it...


 scaricare PhPMyAdmin
EasyPHP nella sua directory ha creato un bel po' di sottodir come **Apache**
, **php** , **mysql** ed anche **phpmyadmin**. Suppongo sia quello che dici
tu... mi sapresti dire in poche parole (o comandi) come lo posso utilizzare?
L'inglese non è il mio forte e in italiano non ho ancora trovato molto...
Grazie

 .........
Non c'è qualcosa in giapponese?

il sapiente ~RicMan~ dice:

non mi sembra un sarcasmo gioviale...
il fatto è che su internet trovare manuali in italiano è sempre stato 
difficile. avvicinarsi all'informatica 'extra Windows' è proprio difficile 
se non mastichi un po' d'inglese!
tra le righe che ti ho postato trovi degli esempi 'isolati' che senza 
conoscenze d'inglese puoi identificare come comandi (mysqld ecc..) . più di 
questo, non so cosa dirti!
ciao!!
-- 
Punkarruso
mail:punkarruso chiocchiolona despammed punto com
pubblicità progresso:
http://www.gnu.org/software/reliability.html

 Non c'è qualcosa in giapponese?
vabbè, trovato!!
http://www.mysql.com/Downloads/Manual/manual.ja.texi.gz
:-)
-- 
Punkarruso
mail:punkarruso chiocchiolona despammed punto com
pubblicità progresso:
http://www.gnu.org/philosophy/free-software-for-freedom.it.html

Apprezzo l'ironia....   :-)
