View previous topic :: View next topic |
Author |
Message |
Angel -
Joined: 17 Nov 2003 Posts: 157 Location: Everett, Washington
|
Posted: Fri May 21, 2004 11:09 am Post subject: FOUND! ONE TUTORIAL FOR NEWBIES 2 CONFIGURE MYSQL!!!! |
|
|
An Awsome Tutorial To Help us Newbies learn how to configure MYsql!!!
PLEASE NOTE this tutorial is for those who still wish to use Mysql 4.1 & 4.0 the inquistor has produced a link below that may work better for those using 5.0 here's the Link www.trustabyss.com
Thanks Inquisitor
http://www.analysisandsolutions.com/code/mybasic.htm
Quote: | Edit
I have decided to Copy and paste the Intructions Just in case something should happen to the orginal page as so often does with websites. Besides this cuts out all the stuff you don't need in the orginal tutorial.
MANY MANY THANKS TO TAASC @ http://www.analysisandsolutions.com FOR YOUR HELP!!!!
|
Here is the Tutorial
PLEASE Note That these Steps should be taken only after following the MySql installation Tutorial found In this forum.
Quote: |
After Editing your My.ini file
1) Make a Command Prompt shortcut to make it easy to manually work with MySQL. By Following these Steps.
Open Windows Explorer.
In the Address Bar, type in %UserProflie% and hit the ENTER key.
Navigate to the Start Menu\Programs\Accessories directory.
Select the Command Prompt file.
Hit CTRL-C then CTRL-V
Or you can create the shortcut By Browsing To C:\Windows\System32\ and right clicking on the CMD.exe and send it to your desktop.
2) Open it's properties via File | Properties and go to the "Shortcut" tab, then the "Start In" box and type in the path where your MySQL binaries are. For example: C:\MySQL\bin Edit the items in the remaining tabs to suit your preferences. Hit OK when you're done.
3) Open the Shortcut Next, we need to "install" the appropriate MySQL service. You have several options. The options and the command to implement it are as follows:
4) Open the MySQL Shortcut. Next, we need to "install" the appropriate
SQL service. You have several options. The options and the command to
implement it are as follows:
NT/2000/XP. Transactions. Named pipes.
Type: mysqld-max-nt --install
To Install NT/2000/XP. Transactions.
Type: mysqld-max --install
To Install NT/2000/XP. Named pipes.
Type: mysqld-nt --install
To Install Transactions.
Type: mysqld --install
To Install Optimised binary with no support for transactional tables.
Type: mysqld-opt --install
5) Next We make sure the MySql Is installed to startup with windows by:
Opening up the Services Manager For your computer
In Windows 2000 Command Prompt Type: services.msc
In Windows NT 4.0 Go to: Start | Settings | Control Panel | Services
In Windows XP Home Or Pro Go To: Start | Settings | Control Panel | Administrative Tools | Component Services
(Note in windows XP pro and Home you will need to click on Services(Local) Once you have opened the Component Services to see the following list)
Highlight the line with "MySql" on it then hit ENTER or double click on it. Set the "Startup type" list to "Automatic" and click Apply.
Click on the Start button. If you get an error message about "Error 1067," it most likely means that some directive in your configuration file (ie my.cnf) is incorrect.
Close the Services Manager.
6) In the Mysql command prompt (ie...the shortcut you created earlier)
You will need to log in.
If you are using a new installation, the root account doesn't have a
password it yet, so type in the text that looks like this:
C:\mysql\bin> mysql -u root mysql
If you have already set a password for root, use these commands:
C:\mysql\bin> mysql -u root -p mysql
Enter password: TYPE IN THE PASSWORD
You will then see the following output:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 3.23.55-max-nt
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
7) Tighten Security
MySQL has good security controls, but the default installation is wide
open. So, if you're doing a new installation, let's close things up before
we go any further. Of course, change NewRootName and NewPassword,
below, to something unique. After typing each line below be sure to hit
enter before typing the next line.
mysql> delete from user where Host='%';
mysql> delete from user where User='';
mysql> delete from db where Host='%';
mysql> update user set User='NewRootName', Password=Password('NewPassword') where User='root';
mysql> flush privileges;
8) Check that your user Name and password are correct.
You will have to log out befor you can use the new user name and pass to do this type:
mysql>exit;
you can now login with the new user name and password by typing once you hit enter you will
be asked for your password MAKE SURE to type it exactly as you did when creating it as MySql
is case sensitive.
C:\mysql\bin> mysql -u root -p mysql
Enter password: TYPE IN THE PASSWORD
|
Thats it folks you can now install phpmyadmin. :) _________________ Noize Pollution | Angel's Online | Free Net Builders | Pagan Portal
Last edited by Angel on Tue Aug 30, 2005 6:51 pm; edited 5 times in total |
|
Back to top |
![ICQ Number ICQ Number](templates/subSilver/images/lang_english/icon_icq_add.gif) |
![](templates/subSilver/images/spacer.gif) |
Foxified -
Joined: 13 Apr 2004 Posts: 487 Location: Canada
|
Posted: Fri May 21, 2004 1:09 pm Post subject: |
|
|
thats more confusing then easy o.o _________________
![](http://michelle.leetone.net/66.jpg) |
|
Back to top |
|
![](templates/subSilver/images/spacer.gif) |
Angel -
Joined: 17 Nov 2003 Posts: 157 Location: Everett, Washington
|
|
Back to top |
![ICQ Number ICQ Number](templates/subSilver/images/lang_english/icon_icq_add.gif) |
![](templates/subSilver/images/spacer.gif) |
goose -
Joined: 17 Sep 2002 Posts: 608 Location: The Land Of OZ! come here toto!
|
Posted: Sat May 22, 2004 6:51 am Post subject: |
|
|
hi have seen this one before. _________________ living in an armish paradise.....no gates here!
mawuahahaha :) |
|
Back to top |
|
![](templates/subSilver/images/spacer.gif) |
Foxified -
Joined: 13 Apr 2004 Posts: 487 Location: Canada
|
Posted: Sat May 22, 2004 8:28 am Post subject: |
|
|
idk, maybe cuz I didnt bother to take a close look. just grabbed scroll bar, scrolled and saw lots of text o.o _________________
![](http://michelle.leetone.net/66.jpg) |
|
Back to top |
|
![](templates/subSilver/images/spacer.gif) |
iXeon -
Joined: 09 Jun 2004 Posts: 1
|
Posted: Wed Jun 09, 2004 9:17 pm Post subject: |
|
|
I have a question, So If I use this and install mySQL... Will it be working without having to integrate it into abyss.... ? |
|
Back to top |
|
![](templates/subSilver/images/spacer.gif) |
Anonymoose -
Joined: 09 Sep 2003 Posts: 2192
|
Posted: Wed Jun 09, 2004 9:36 pm Post subject: |
|
|
There is no integration with Abyss - MySQL is an entirely separate entity. It's any scripts you set up which will be connecting to it. Scripts are processed by their interpreter, not Abyss web server. |
|
Back to top |
|
![](templates/subSilver/images/spacer.gif) |
Angel -
Joined: 17 Nov 2003 Posts: 157 Location: Everett, Washington
|
|
Back to top |
![ICQ Number ICQ Number](templates/subSilver/images/lang_english/icon_icq_add.gif) |
![](templates/subSilver/images/spacer.gif) |
Bloodbath187 -
Joined: 25 Jan 2004 Posts: 6
|
Posted: Fri Jul 30, 2004 1:30 am Post subject: Excellent |
|
|
Great tutorial, it helped me out alot, thanks. |
|
Back to top |
|
![](templates/subSilver/images/spacer.gif) |
Angel -
Joined: 17 Nov 2003 Posts: 157 Location: Everett, Washington
|
|
Back to top |
![ICQ Number ICQ Number](templates/subSilver/images/lang_english/icon_icq_add.gif) |
![](templates/subSilver/images/spacer.gif) |
vhsorless -
Joined: 25 Jan 2005 Posts: 45
|
Posted: Thu Feb 03, 2005 12:30 am Post subject: |
|
|
Quote: |
4) Open the MySQL Shortcut. Next, we need to "install" the appropriate
SQL service. You have several options. The options and the command to
implement it are as follows:
NT/2000/XP. Transactions. Named pipes.
Type: mysqld-max-nt --install
To Install NT/2000/XP. Transactions.
Type: mysqld-max --install
To Install NT/2000/XP. Named pipes.
Type: mysqld-nt --install
To Install Transactions.
Type: mysqld --install
To Install Optimised binary with no support for transactional tables.
Type: mysqld-opt --install |
Okay, this looks great, but I'm not sure which install of MySQL I need.
EDIT: Ok, I've got MySQL and phpMyAdmin up and running now (in addition to MySQL Administrator), thanks to this tutorial, but now I'm getting a new error when I access phpMyAdmin. I can login, but I get this once I'm inside phpMyAdmin:
The mbstring PHP extension was not found and you seem to be using multibyte charset. Without mbstring extension phpMyAdmin is unable to split strings correctly and it may result in unexpected results.
MySQL Administrator works fine with MySQL 5, by the way. :) _________________ I.P. Daily,
VHS Connoisseur |
|
Back to top |
|
![](templates/subSilver/images/spacer.gif) |
AICkieranAIC -
Joined: 04 May 2005 Posts: 1
|
Posted: Wed May 04, 2005 9:29 am Post subject: ... |
|
|
Ok well firstly check php.ini and other config files such as mysql configs. Also in the phpMyAdmin config theres the authentication stuff, make sure you set it as "http" and not the default (config) i hope this helps, As with most SSI/databases its just about playing with the settings untill you get what you need. Just look for familiar terms that apply to the errors you get. but if you dont know what something is either
a) Leave it
b) google it
I have recently started using Abyss instead of apache for the simple reason its a home server it seems to be just as good and configurable. also i have remote control over it :D
EDIT: poo, shoulda checked the date of posts.. Well i hope you have got it sorted by now, if not hope this works |
|
Back to top |
|
![](templates/subSilver/images/spacer.gif) |
TRUSTAbyss -
Joined: 29 Oct 2003 Posts: 3752 Location: USA, GA
|
Posted: Wed May 04, 2005 10:22 am Post subject: |
|
|
vhsorless wrote: |
The mbstring PHP extension was not found and you seem to be using multibyte charset. Without mbstring extension phpMyAdmin is unable to split strings correctly and it may result in unexpected results.
|
Please enable the php_mbstring.dll in your php.ini , for some reason the newer
versions of phpMyAdmin want the mbstring function enabled , I don't know why. |
|
Back to top |
|
![](templates/subSilver/images/spacer.gif) |
grandadmiral -
Joined: 21 Apr 2003 Posts: 5
|
Posted: Tue May 17, 2005 6:20 am Post subject: |
|
|
TRUSTpunk wrote: | vhsorless wrote: |
The mbstring PHP extension was not found and you seem to be using multibyte charset. Without mbstring extension phpMyAdmin is unable to split strings correctly and it may result in unexpected results.
|
Please enable the php_mbstring.dll in your php.ini , for some reason the newer
versions of phpMyAdmin want the mbstring function enabled , I don't know why. |
How is this done? I'm lost finding it in my php.ini.
***EDIT***
Ok. Found what I was looking for but it seems like it was already enabled (extension is listed in the extensions list). Could there be something else wrong?
***EDIT II***
Ok. Fixed it. Sorry for the waste of space. |
|
Back to top |
|
![](templates/subSilver/images/spacer.gif) |
Hunted -
Joined: 24 Nov 2003 Posts: 71
|
Posted: Tue Aug 30, 2005 1:37 am Post subject: |
|
|
I get this error for everything... phpMyAdmin... and now that...
![](http://img369.imageshack.us/img369/9012/mysqlcmd5xu.jpg) |
|
Back to top |
|
![](templates/subSilver/images/spacer.gif) |
AbyssUnderground -
Joined: 31 Dec 2004 Posts: 3855
|
Posted: Tue Aug 30, 2005 9:23 am Post subject: |
|
|
There is a simpler tutorial on www.trustabyss.com for PHP, MySQL and phpMyAdmin. _________________ Andy (AbyssUnderground) (previously The Inquisitor)
www.abyssunderground.co.uk |
|
Back to top |
|
![](templates/subSilver/images/spacer.gif) |
Angel -
Joined: 17 Nov 2003 Posts: 157 Location: Everett, Washington
|
Posted: Tue Aug 30, 2005 6:34 pm Post subject: |
|
|
Please note that I Put this Tutorial here Before MySql 5.0 Came out this particular Tutorial Works Better With 4.1 and 4.0 You might try The Inquisitor's advice and chech out his link. _________________ Noize Pollution | Angel's Online | Free Net Builders | Pagan Portal |
|
Back to top |
![ICQ Number ICQ Number](templates/subSilver/images/lang_english/icon_icq_add.gif) |
![](templates/subSilver/images/spacer.gif) |
pjanak -
Joined: 05 Apr 2006 Posts: 8
|
Posted: Fri Apr 07, 2006 6:40 am Post subject: |
|
|
What is MySGL. okay its a database program. But what does it do for me the layman. What is its pupose. Like ah When does a website need a database |
|
Back to top |
|
![](templates/subSilver/images/spacer.gif) |
Angel -
Joined: 17 Nov 2003 Posts: 157 Location: Everett, Washington
|
|
Back to top |
![ICQ Number ICQ Number](templates/subSilver/images/lang_english/icon_icq_add.gif) |
![](templates/subSilver/images/spacer.gif) |
Adam123 -
Joined: 15 Apr 2006 Posts: 36
|
Posted: Sat Apr 15, 2006 7:49 pm Post subject: |
|
|
I got a error in phpadmin
it says
#1045 - Access denied for user 'adamsnake'@'localhost' (using password: YES) |
|
Back to top |
|
![](templates/subSilver/images/spacer.gif) |
aprelium -
Joined: 22 Mar 2002 Posts: 6800
|
Posted: Sun Apr 16, 2006 2:27 pm Post subject: |
|
|
Adam123,
The password you have entered is either wrong or the user is not allowed access. Try logging using your database administrator login/password. Later you can check, add, and remove limited user permissions in MySQL.
If you have forgot the administrator password in MySQL, run Start > Programs > MySQL > MySQL version X.Y > MySQL Server Instance Config Wizard to choose a new password . _________________ Support Team
Aprelium - http://www.aprelium.com |
|
Back to top |
|
![](templates/subSilver/images/spacer.gif) |
|