| Author |
|
James Blond
Moderator
Joined: 19 Jan 2006
Posts: 7377
Location: Germany, Next to Hamburg
|
 Posted: Wed 04 Jun '08 10:56 Post subject: |
 |
|
| Jakesy-2K8 wrote: |
i cant do coz when i put mysqld-nt.exe --install the cmd window doesnt recognize it so dont i have to put something else in the cmd window 1st or when i open the cmd window do i just put mysqld-nt.exe --install in
|
| Code: |
cd \
cd mysql
cd bin
mysqld-nt --install
|
|
|
| Back to top |
|
Jakesy-2K8
Joined: 01 Jun 2008
Posts: 21
Location: Chesterfield,Derbyshire
|
| Posted: Wed 04 Jun '08 11:49 Post subject: |
|
|
right that has worked so thank you very much for all your help on this
if i need help ,which i think i will then i will post back here cheers. |
|
| Back to top |
|
Jakesy-2K8
Joined: 01 Jun 2008
Posts: 21
Location: Chesterfield,Derbyshire
|
| Posted: Wed 04 Jun '08 19:54 Post subject: |
|
|
i need to change the username and password on mysql but do i change it here ...
# The following options will be passed to all MySQL clients
[client]
#password = your password
port = 3306
socket = /tmp/mysql.sock
that above is out of my.ini so is that where i change the password and things thank you |
|
| Back to top |
|
James Blond
Moderator
Joined: 19 Jan 2006
Posts: 7377
Location: Germany, Next to Hamburg
|
|
| Back to top |
|
Jakesy-2K8
Joined: 01 Jun 2008
Posts: 21
Location: Chesterfield,Derbyshire
|
| Posted: Thu 05 Jun '08 14:33 Post subject: |
|
|
ok i got cmd.exe box up so what do i put in there to change the passwords and usernames so that when i get it up and running ,no 1 can get into the database or anywhere else, oh yes i have unzipped phpmyadmin to c:\apache2\htdocs and when i go onto localhost it just comes up with a blue list like FTP
and i have read that link that you sent above but i cant understand alot of it as like i keep saying i am really new to all this lol
however i really do appreciate all this that you are doing for me and i cant wait to get a forum up and running
also when it is all done and complete, will this happen or not "if i shut down my pc the website that i make is gone until i turn the pc back on again because that what happend last time but i was using dynamic something or other so that people could get on to my site" cant remember what it was now sorry
and also i have got to be very carefull because last time i did this (but with auto installers) quite a few people got into the database because i didnt no how to change the passwords.
like i said above i am really grateful of all this so thank you very much.
p.s
9a. install phpmyadmin with the installer script in http://yourdomain.tld/phpmyadmin/scripts/setup.php
the link above in red dont work cheers.
so how can i install phpmyadmin thanks |
|
| Back to top |
|
James Blond
Moderator
Joined: 19 Jan 2006
Posts: 7377
Location: Germany, Next to Hamburg
|
| Posted: Thu 05 Jun '08 16:25 Post subject: |
|
|
| Jakesy-2K8 wrote: | oh yes i have unzipped phpmyadmin to c:\apache2\htdocs and when i go onto localhost it just comes up with a blue list like FTP
|
Are you sure that your server parses PHP pages?
| Jakesy-2K8 wrote: |
http://yourdomain.tld/phpmyadmin/scripts/setup.php
|
Can you open http://youdomain/phpmyadmin/ ? Did you try http://localhost/phpmyadmin/scripts/setup.php ? |
|
| Back to top |
|
Jakesy-2K8
Joined: 01 Jun 2008
Posts: 21
Location: Chesterfield,Derbyshire
|
| Posted: Fri 06 Jun '08 13:29 Post subject: |
|
|
this is what i get when i go to http://localhost/phpmyadmin/scripts/setup.php%20?
| Quote: | Welcome
You want to configure phpMyAdmin using web interface. Please note that this only allows basic setup, please read documentation to see full description of all configuration directives. |
| Quote: | Can not load or save configuration
Please create web server writable folder config in phpMyAdmin toplevel directory as described in documentation. Otherwise you will be only able to download or display it. |
| Quote: | Not secure connection
You are not using secure connection, all data (including sensitive, like passwords) are transfered unencrypted! If your server is also configured to accept HTTPS request follow this link to use secure connection.
|
Available global actions (please note that these will delete any changes you could have done above):
Servers...
ADD.
Layout...
NAVIGATION FRAME / TABS / ICONS / BROWSING / EDITING / QUERY WINDOW.
Features...
UPLOAD/DOWNLOAD / SECURITY / MYSQL MANUAL / CHARSETS / EXTENSIONS / MIME/RELATION/HISTORY.
Configuration...
OVERVIEW / DISPLAY / DOWNLOAD / SAVE / LOAD / CLEAR / DOS/WINDOWS(\r\n) / CHANGE END OF LINE.
Other actions...
CHECK FOR LATEST VERSION / GOTO HOMEPAGE / DONATE TO PHPMYADMIN.
the save and load on config part above are not highlighted so they cant be pressed
thats what i get when i go to http://localhost/phpmyadmin/scripts/setup.php%20?
thank you
And also when i go to http://youdomain/phpmyadmin/
it says
Not Found
The requested URL /phpmyadmin/ was not found on this server.
Apache/2.0.54 (Unix) mod_ssl/2.0.54 OpenSSL/0.9.7g PHP/4.4.0 Server at www.youdomain.com Port 80
Also i tried that link by putting a R in youRdomain so it was
http://youRdomain/phpmyadmin/
because i didnt no if you had missed the R out of the link and i got this...
Sorry, the page you requested cannot be found
Please click [url]here[/url] to return to our home page.
Thank you for all your help and i cant wait to get my forum up and running
also what forum do you think is the best to get and also is pretty reliable cheers |
|
| Back to top |
|
James Blond
Moderator
Joined: 19 Jan 2006
Posts: 7377
Location: Germany, Next to Hamburg
|
| Posted: Sun 08 Jun '08 13:48 Post subject: |
|
|
hey dude, you can note use "yourydomain.com" that is only an example! if you don't have any name use only localhost as name.
http://localhost/phpmyadmin/scripts/setup.php outout is fine! Did you follow the setup? Made what it wanted from you? |
|
| Back to top |
|
Jakesy-2K8
Joined: 01 Jun 2008
Posts: 21
Location: Chesterfield,Derbyshire
|
| Posted: Sun 08 Jun '08 22:34 Post subject: |
|
|
hey man ,im totally lost now and aint got a clue what to do and if your on about the set up as in the tutorial then i got to this bit ...
After you install the service be sure to:
Secure the initial MySQL accounts MySQL access controls. Be aware that default both root and the anonymous account are set up with no password, so anyone can connect to the MySQL server as root.
but i havent got a clue what to do now and i am so wanting this to make a forum
and so your saying that this below...
http://localhost/phpmyadmin/scripts/setup.php
is done ok and also when i click ADD server on http://localhost/phpmyadmin/scripts/setup.php
i dont have a clue what to put in all the boxes lol
sorry about this
so is that were i put in a password and things mate in...
http://localhost/phpmyadmin/scripts/setup.php << and is that the database
also is there a easier automatic way to do all this lol cheers |
|
| Back to top |
|
James Blond
Moderator
Joined: 19 Jan 2006
Posts: 7377
Location: Germany, Next to Hamburg
|
|
| Back to top |
|
