Know of a free database software?

All about creating websites!
Post Reply
User avatar
Asuna
suck-o-fied!
suck-o-fied!
Posts: 92
Joined: 27 Dec 2006, 17:00
17
Location: New York, USA

Know of a free database software?

Post by Asuna »

I was wondering... is there any free database software out there (like maybe some free (but legal) version of MySQL or Microsoft Access). I need something that I can use to code .asp pages for my website. The database will be used for usernames, passwords, etc. . If you know any, would you mind sharing?

~Thanks

Question: b_b, what database software do you use? and, is it free?

User avatar
mo2332
Fame ! Where are the chicks?!
Fame ! Where are the chicks?!
Posts: 705
Joined: 28 Apr 2007, 16:00
16
Contact:

Post by mo2332 »

yeh i think cpanel mighta be

User avatar
Asuna
suck-o-fied!
suck-o-fied!
Posts: 92
Joined: 27 Dec 2006, 17:00
17
Location: New York, USA

Post by Asuna »

awsome. do you know where i could download that?

~Thanks

User avatar
Gogeta70
^_^
^_^
Posts: 3275
Joined: 25 Jun 2005, 16:00
18

Post by Gogeta70 »

You can download mysql for free...
¯\_(ツ)_/¯ It works on my machine...

shamir
Computer Manager
Computer Manager
Posts: 853
Joined: 01 Mar 2007, 17:00
17
Location: NY
Contact:

Post by shamir »


User avatar
bad_brain
Site Owner
Site Owner
Posts: 11636
Joined: 06 Apr 2005, 16:00
19
Location: In your eye floaters.
Contact:

Post by bad_brain »

yeup, mysql IS free....if you need a web administration interface get phpmyadmin:
http://www.phpmyadmin.net/home_page/index.php

:wink:

bubzuru
.net coder
.net coder
Posts: 700
Joined: 17 Apr 2007, 16:00
17
Contact:

Post by bubzuru »

or get wamp server that will install it all ready for you

http://www.wampserver.com/dl.php

Apache 2.2.4
PHP 5.2.4 + PECL
SQLitemanager
MySQL 5.0.45
Phpmyadmin

User avatar
Asuna
suck-o-fied!
suck-o-fied!
Posts: 92
Joined: 27 Dec 2006, 17:00
17
Location: New York, USA

Post by Asuna »

thanks. I'm using the wamp thing. but, now i have some problems i need to address (fyi: i'm a total newbie at this). When I start the MySQL service, a few moments later, it stops the service. And when I try to access PHPMyAdmin, it tells me:

Code: Select all

phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.

Error
MySQL said:  

#1045 - Access denied for user 'root'@'localhost' (using password: NO)  
Why does the service just end and how do i change the username and password for the MySQL server (or is that not the problem)?

Apache works just fine... it's just those two. Do I need to do something to my configuration files? I just installed this about 10 minutes ago, and I didn't change anything? Am I missing something?

bubzuru
.net coder
.net coder
Posts: 700
Joined: 17 Apr 2007, 16:00
17
Contact:

Post by bubzuru »

it works fine for me try to click on the icon
and select put Online

User avatar
bad_brain
Site Owner
Site Owner
Posts: 11636
Joined: 06 Apr 2005, 16:00
19
Location: In your eye floaters.
Contact:

Post by bad_brain »

phpmyadmin will not be functional as long as MySQL is not running properly as service.
try this and look if MySQL keeps running then:

Code: Select all

start wamp and left click on the wamp system tray icon -> php settings -> php extensions -> php_mysql -> restart wamp

:wink:

p.s. what OS are you using btw?

User avatar
Asuna
suck-o-fied!
suck-o-fied!
Posts: 92
Joined: 27 Dec 2006, 17:00
17
Location: New York, USA

Post by Asuna »

Windows XP - Media Center Edition.

Here's the MySQL error log:

Code: Select all

InnoDB: The first specified data file .\ibdata1 did not exist:
InnoDB: a new database to be created!
071025 19:14:53  InnoDB: Setting file .\ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
071025 19:14:54  InnoDB: Log file .\ib_logfile0 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile0 size to 10 MB
InnoDB: Database physically writes the file full: wait...
071025 19:14:54  InnoDB: Log file .\ib_logfile1 did not exist: new to be created
InnoDB: Setting log file .\ib_logfile1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
071025 19:14:56  InnoDB: Started; log sequence number 0 0
071025 19:14:56 [ERROR] Do you already have another mysqld server running on port: 3306 ?
071025 19:14:56 [ERROR] Aborting

071025 19:14:56  InnoDB: Starting shutdown...
071025 19:14:58  InnoDB: Shutdown completed; log sequence number 0 43655
071025 19:14:58 [Note] c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown complete

071025 19:16:25  InnoDB: Started; log sequence number 0 43655
071025 19:16:25 [ERROR] Do you already have another mysqld server running on port: 3306 ?
071025 19:16:25 [ERROR] Aborting

071025 19:16:25  InnoDB: Starting shutdown...
071025 19:16:27  InnoDB: Shutdown completed; log sequence number 0 43655
071025 19:16:27 [Note] c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown complete

071025 19:18:53  InnoDB: Started; log sequence number 0 43655
071025 19:18:53 [ERROR] Do you already have another mysqld server running on port: 3306 ?
071025 19:18:53 [ERROR] Aborting

071025 19:18:53  InnoDB: Starting shutdown...
071025 19:18:56  InnoDB: Shutdown completed; log sequence number 0 43655
071025 19:18:56 [Note] c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown complete

071025 19:19:10  InnoDB: Started; log sequence number 0 43655
071025 19:19:10 [ERROR] Do you already have another mysqld server running on port: 3306 ?
071025 19:19:10 [ERROR] Aborting

071025 19:19:10  InnoDB: Starting shutdown...
071025 19:19:12  InnoDB: Shutdown completed; log sequence number 0 43655
071025 19:19:12 [Note] c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown complete

071025 19:19:22  InnoDB: Started; log sequence number 0 43655
071025 19:19:22 [ERROR] Do you already have another mysqld server running on port: 3306 ?
071025 19:19:22 [ERROR] Aborting

071025 19:19:22  InnoDB: Starting shutdown...
071025 19:19:25  InnoDB: Shutdown completed; log sequence number 0 43655
071025 19:19:25 [Note] c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown complete

071025 19:19:42  InnoDB: Started; log sequence number 0 43655
071025 19:19:42 [ERROR] Do you already have another mysqld server running on port: 3306 ?
071025 19:19:42 [ERROR] Aborting

071025 19:19:42  InnoDB: Starting shutdown...
071025 19:19:44  InnoDB: Shutdown completed; log sequence number 0 43655
071025 19:19:44 [Note] c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown complete

071025 19:20:50  InnoDB: Started; log sequence number 0 43655
071025 19:20:50 [ERROR] Do you already have another mysqld server running on port: 3306 ?
071025 19:20:50 [ERROR] Aborting

071025 19:20:50  InnoDB: Starting shutdown...
071025 19:20:52  InnoDB: Shutdown completed; log sequence number 0 43655
071025 19:20:52 [Note] c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown complete

071025 19:23:02  InnoDB: Started; log sequence number 0 43655
071025 19:23:02 [ERROR] Do you already have another mysqld server running on port: 3306 ?
071025 19:23:02 [ERROR] Aborting

071025 19:23:02  InnoDB: Starting shutdown...
071025 19:23:04  InnoDB: Shutdown completed; log sequence number 0 43655
071025 19:23:04 [Note] c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown complete

071025 19:24:09  InnoDB: Started; log sequence number 0 43655
071025 19:24:09 [ERROR] Do you already have another mysqld server running on port: 3306 ?
071025 19:24:09 [ERROR] Aborting

071025 19:24:09  InnoDB: Starting shutdown...
071025 19:24:12  InnoDB: Shutdown completed; log sequence number 0 43655
071025 19:24:12 [Note] c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown complete

071026 18:03:39  InnoDB: Started; log sequence number 0 43655
071026 18:03:39 [ERROR] Do you already have another mysqld server running on port: 3306 ?
071026 18:03:39 [ERROR] Aborting

071026 18:03:39  InnoDB: Starting shutdown...
071026 18:03:42  InnoDB: Shutdown completed; log sequence number 0 43655
071026 18:03:42 [Note] c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown complete

071026 18:04:40  InnoDB: Started; log sequence number 0 43655
071026 18:04:40 [ERROR] Do you already have another mysqld server running on port: 3306 ?
071026 18:04:40 [ERROR] Aborting

071026 18:04:40  InnoDB: Starting shutdown...
071026 18:04:44  InnoDB: Shutdown completed; log sequence number 0 43655
071026 18:04:44 [Note] c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown complete

071026 18:05:56  InnoDB: Started; log sequence number 0 43655
071026 18:05:56 [ERROR] Do you already have another mysqld server running on port: 3306 ?
071026 18:05:56 [ERROR] Aborting

071026 18:05:56  InnoDB: Starting shutdown...
071026 18:06:01  InnoDB: Shutdown completed; log sequence number 0 43655
071026 18:06:01 [Note] c:\wamp\mysql\bin\mysqld-nt.exe: Shutdown complete

[/code]

Post Reply