[RESOLVED] Mysql error 1067

[LukaszT]

Sup?
I have tried everything after I formatted my laptop.
MySQL error 1067
The port isn't used I tried another port nothing helped.
It works fine from the console when I use mysqld-nt.exe --console, it says it is ready for connections. It worked fine with Norton on the last windows installation
Even microsoft forums are having problems atm
apache_2.0.59-win32-x86-no_ssl
mysql-essential-5.0.27-win32
php-4.4.4-Win32

My.ini

[client]
port=3306
[mysql]
default-character-set=latin1
[mysqld]
port=3306
default-character-set=latin1
basedir="C:/Program Files/Apache Group/Apache2/MySQL/"
datadir="C:/Program Files/Apache Group/Apache2/MySQL/data/"

That is my configuration in my.ini in C:\Windows

Once I get that error fixed I put it in apache folder.
I even rebooted my laptop, and nothing helped

[bpat1434]

So you installed MySQL to the Apache2 folder? Kind of odd.

EDIT: Debunked my own theory 🙁

But anyway, have you checked whether or not the path is completely correct? I.e. there isn't a sub-folder that needs to be specified?

[LukaszT]

Hey bpat1434 How Are Ya?
it is "Apache2" not Apache 2
There is no spaces I just checked
I installed MySQL into the apache folder.
It worked fine last windows instalation
My.ini will go into the apache folder after I get the error fixed
My.ini is in C:\Windows now
It doesn't work now

[bpat1434]

Is the path in the windows Environment Variables?

Have you tried putting the INI file where it should be, and not in the Windows directory?

[LukaszT]

Hey Sup? bpat1434
How do I set mysql path in enviromental tables, I know how to get into there but I dunno the code for it and what should be the value called

[bpat1434]

In the Environment Variables, you should see one called "PATH". Edit that, and see if you have "C:\Program Files\Apache Group\Apache2\MySQL\bin" in there. If you don't, just add it. When adding, make sure you separate the previous entry and the new one with a semi-colon: ";".

[LukaszT]

Hey bpat1434
I did like you said it didn't work
I attached some pictures for easier use
Please help

[bpat1434]

Not sure what to tell you. It probably should have worked. Have you tried uninstalling and then re-installing?

Have you used the MySQL Configurator?

[LukaszT]

Sup?
I will try to uninstall it again with the path already in there again, but atm I am very tired.

[walleyg]

Luk
I am working on the same prob with xp-pro-64. I have apache2 and php5 working fine.
Working on getting MySQL 5 working. My design puter is xp-pro SP2 and everything works great.
I think I will uninstall and reinstall in the root directory and get rid of the path ....Program files(x86)...
I may even try a manual install since that worked the best in the design puter.
Be back soon to tell you my results.
GB
Walt

[LukaszT]

so how are ya?
did you solve your problem.
I havn't solved the problem yet

[xster]

if you install mysql under windows system, sometime it will suddenly unable to start the service,
i face this issue quite a few times already, finally i found a solution for it,

1st step check the error, under your installation path for mysql, check the data/mysql.err, it the error showing you something like this ..

050213 20:43:37 InnoDB: Starting shutdown…
050213 20:43:40 InnoDB: Shutdown completed; log sequence number 0 1051715
050213 20:43:40 [Note] C:\Web\mysql\bin\mysqld-nt: Shutdown complete

this should be the log file having problem!

2nd step remove the ib_logfile0 or ib_logfile1 in the same folder

3rd step restart the mysql…

da da da… mysql service is running again

p/s: i'd got the same problem and i tried the tips ahead, its works for me..try and error would give you experience...hope this will help... XD

[LukaszT]

Sup?
I have finally solved the problem by uninstalling mysql
then what I did was install it but K:\Apache\MySQL\MySQL Server 5.0
It has to be that long or else it won't work.
base dir is where you installed your mysql server
data dir is where your data files are
make sure you change base directory and data direcoty folder where you installed it and innodb dir as well
My my.ini

[client]
#password	= your_password
port		= 3306
socket		= /tmp/mysql.sock

# Here follows entries for some specific programs

# The MySQL server
[mysqld]
port		= 3306
socket		= /tmp/mysql.sock
skip-locking
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
basedir=K:/Apache/MySQL/MySQL Server 5.0
datadir=K:/Apache/MySQL/MySQL Server 5.0/data
# Don't listen on a TCP/IP port at all. This can be a security enhancement,
# if all processes that need to connect to mysqld run on the same host.
# All interaction with mysqld must be made via Unix sockets or named pipes.
# Note that using this option without enabling named pipes on Windows
# (via the "enable-named-pipe" option) will render mysqld useless!
# 
#skip-networking

# Replication Master Server (default)
# binary logging is required for replication
log-bin=mysql-bin

# required unique id between 1 and 2^32 - 1
# defaults to 1 if master-host is not set
# but will not function as a master if omitted
server-id	= 1

# Replication Slave (comment out master section to use this)
#
# To configure this host as a replication slave, you can choose between
# two methods :
#
# 1) Use the CHANGE MASTER TO command (fully described in our manual) -
#    the syntax is:
#
#    CHANGE MASTER TO MASTER_HOST=<host>, MASTER_PORT=<port>,
#    MASTER_USER=<user>, MASTER_PASSWORD=<password> ;
#
#    where you replace <host>, <user>, <password> by quoted strings and
#    <port> by the master's port number (3306 by default).
#
#    Example:
#
#    CHANGE MASTER TO MASTER_HOST='125.564.12.1', MASTER_PORT=3306,
#    MASTER_USER='joe', MASTER_PASSWORD='secret';
#
# OR
#
# 2) Set the variables below. However, in case you choose this method, then
#    start replication for the first time (even unsuccessfully, for example
#    if you mistyped the password in master-password and the slave fails to
#    connect), the slave will create a master.info file, and any later
#    change in this file to the variables' values below will be ignored and
#    overridden by the content of the master.info file, unless you shutdown
#    the slave server, delete master.info and restart the slaver server.
#    For that reason, you may want to leave the lines below untouched
#    (commented) and instead use CHANGE MASTER TO (see above)
#
# required unique id between 2 and 2^32 - 1
# (and different from the master)
# defaults to 2 if master-host is set
# but will not function as a slave if omitted
#server-id       = 2
#
# The replication master for this slave - required
#master-host     =   <hostname>
#
# The username the slave will use for authentication when connecting
# to the master - required
#master-user     =   <username>
#
# The password the slave will authenticate with when connecting to
# the master - required
#master-password =   <password>
#
# The port the master is listening on.
# optional - defaults to 3306
#master-port     =  <port>
#
# binary logging - not required for slaves, but recommended
#log-bin=mysql-bin

# Point the following paths to different dedicated disks
#tmpdir		= /tmp/		
#log-update 	= /path-to-dedicated-directory/hostname

# Uncomment the following if you are using BDB tables
#bdb_cache_size = 4M
#bdb_max_lock = 10000

# Uncomment the following if you are using InnoDB tables
#innodb_data_home_dir = K:/Apache/MySQL/MySQL Server 5.0/data
innodb_data_file_path = ibdata1:10M:autoextend
#innodb_log_group_home_dir = /usr/local/var/
#innodb_log_arch_dir = /usr/local/var/
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
#innodb_buffer_pool_size = 16M
#innodb_additional_mem_pool_size = 2M
# Set .._log_file_size to 25 % of buffer pool size
#innodb_log_file_size = 5M
#innodb_log_buffer_size = 8M
#innodb_flush_log_at_trx_commit = 1
#innodb_lock_wait_timeout = 50

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[isamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[myisamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout

[LukaszT]

hey sup evryone

here is a demo of phpmyadmin
PhpMyAdmin Enter Here
username "demo" password "demo"
without the quotes
My website
Enter My Site