FOUND! ONE TUTORIAL FOR NEWBIES 2 CONFIGURE MYSQL!!!!

 
Post new topic   Reply to topic    Aprelium Forum Index -> Tutorials
View previous topic :: View next topic  
Author Message
Angel
-


Joined: 17 Nov 2003
Posts: 157
Location: Everett, Washington

PostPosted: Fri May 21, 2004 11:09 am    Post subject: FOUND! ONE TUTORIAL FOR NEWBIES 2 CONFIGURE MYSQL!!!! Reply with quote

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 View user's profile Send private message Send e-mail Visit poster's website AIM Address Yahoo Messenger MSN Messenger ICQ Number
Foxified
-


Joined: 13 Apr 2004
Posts: 487
Location: Canada

PostPosted: Fri May 21, 2004 1:09 pm    Post subject: Reply with quote

thats more confusing then easy o.o
_________________
Back to top View user's profile Send private message Visit poster's website AIM Address MSN Messenger
Angel
-


Joined: 17 Nov 2003
Posts: 157
Location: Everett, Washington

PostPosted: Fri May 21, 2004 8:33 pm    Post subject: Reply with quote

Foxified wrote:
thats more confusing then easy o.o


I found it pretty easy myself so might others.
_________________
Noize Pollution | Angel's Online | Free Net Builders | Pagan Portal
Back to top View user's profile Send private message Send e-mail Visit poster's website AIM Address Yahoo Messenger MSN Messenger ICQ Number
goose
-


Joined: 17 Sep 2002
Posts: 608
Location: The Land Of OZ! come here toto!

PostPosted: Sat May 22, 2004 6:51 am    Post subject: Reply with quote

hi have seen this one before.
_________________
living in an armish paradise.....no gates here!

mawuahahaha :)
Back to top View user's profile Send private message
Foxified
-


Joined: 13 Apr 2004
Posts: 487
Location: Canada

PostPosted: Sat May 22, 2004 8:28 am    Post subject: Reply with quote

idk, maybe cuz I didnt bother to take a close look. just grabbed scroll bar, scrolled and saw lots of text o.o
_________________
Back to top View user's profile Send private message Visit poster's website AIM Address MSN Messenger
iXeon
-


Joined: 09 Jun 2004
Posts: 1

PostPosted: Wed Jun 09, 2004 9:17 pm    Post subject: Reply with quote

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 View user's profile Send private message
Anonymoose
-


Joined: 09 Sep 2003
Posts: 2192

PostPosted: Wed Jun 09, 2004 9:36 pm    Post subject: Reply with quote

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 View user's profile Send private message
Angel
-


Joined: 17 Nov 2003
Posts: 157
Location: Everett, Washington

PostPosted: Fri Jun 11, 2004 2:02 am    Post subject: I just needed Reply with quote

when I found this I needed something to show me how to build and work with tables and it helped.
_________________
Noize Pollution | Angel's Online | Free Net Builders | Pagan Portal
Back to top View user's profile Send private message Send e-mail Visit poster's website AIM Address Yahoo Messenger MSN Messenger ICQ Number
Bloodbath187
-


Joined: 25 Jan 2004
Posts: 6

PostPosted: Fri Jul 30, 2004 1:30 am    Post subject: Excellent Reply with quote

Great tutorial, it helped me out alot, thanks.
Back to top View user's profile Send private message
Angel
-


Joined: 17 Nov 2003
Posts: 157
Location: Everett, Washington

PostPosted: Fri Aug 13, 2004 8:35 am    Post subject: YQW Reply with quote

Your very welcome glad it helped!
_________________
Noize Pollution | Angel's Online | Free Net Builders | Pagan Portal
Back to top View user's profile Send private message Send e-mail Visit poster's website AIM Address Yahoo Messenger MSN Messenger ICQ Number
vhsorless
-


Joined: 25 Jan 2005
Posts: 45

PostPosted: Thu Feb 03, 2005 12:30 am    Post subject: Reply with quote

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 View user's profile Send private message
AICkieranAIC
-


Joined: 04 May 2005
Posts: 1

PostPosted: Wed May 04, 2005 9:29 am    Post subject: ... Reply with quote

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 View user's profile Send private message
TRUSTAbyss
-


Joined: 29 Oct 2003
Posts: 3714
Location: USA, GA

PostPosted: Wed May 04, 2005 10:22 am    Post subject: Reply with quote

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.
_________________
Computer Programmer & Networking Specialist

Back to top View user's profile Send private message Visit poster's website MSN Messenger
grandadmiral
-


Joined: 21 Apr 2003
Posts: 5

PostPosted: Tue May 17, 2005 6:20 am    Post subject: Reply with quote

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 View user's profile Send private message
Hunted
-


Joined: 24 Nov 2003
Posts: 71

PostPosted: Tue Aug 30, 2005 1:37 am    Post subject: Reply with quote

I get this error for everything... phpMyAdmin... and now that...
Back to top View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger MSN Messenger
AbyssUnderground
-


Joined: 31 Dec 2004
Posts: 3855

PostPosted: Tue Aug 30, 2005 9:23 am    Post subject: Reply with quote

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 View user's profile Send private message Visit poster's website
Angel
-


Joined: 17 Nov 2003
Posts: 157
Location: Everett, Washington

PostPosted: Tue Aug 30, 2005 6:34 pm    Post subject: Reply with quote

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 View user's profile Send private message Send e-mail Visit poster's website AIM Address Yahoo Messenger MSN Messenger ICQ Number
pjanak
-


Joined: 05 Apr 2006
Posts: 8

PostPosted: Fri Apr 07, 2006 6:40 am    Post subject: Reply with quote

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 View user's profile Send private message MSN Messenger
Angel
-


Joined: 17 Nov 2003
Posts: 157
Location: Everett, Washington

PostPosted: Fri Apr 07, 2006 3:18 pm    Post subject: Reply with quote

basically mysql can hold information in it about scripts. such as username and passwords, or forum names thing's like that.
_________________
Noize Pollution | Angel's Online | Free Net Builders | Pagan Portal
Back to top View user's profile Send private message Send e-mail Visit poster's website AIM Address Yahoo Messenger MSN Messenger ICQ Number
Adam123
-


Joined: 15 Apr 2006
Posts: 36

PostPosted: Sat Apr 15, 2006 7:49 pm    Post subject: Reply with quote

I got a error in phpadmin

it says

#1045 - Access denied for user 'adamsnake'@'localhost' (using password: YES)
Back to top View user's profile Send private message
aprelium
-


Joined: 22 Mar 2002
Posts: 6800

PostPosted: Sun Apr 16, 2006 2:27 pm    Post subject: Reply with quote

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 View user's profile Send private message Send e-mail
Display posts from previous:   
Post new topic   Reply to topic    Aprelium Forum Index -> Tutorials All times are GMT + 1 Hour
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB phpBB Group