Ubuntu :: ERROR 1006 (HY000): Can't Create Database

Mar 13, 2011

PHP Code:

#mysql -u root -pPassWordmysql> create database whatever;ERROR 1006 (HY000): Can't create database 'whatever (errno: 13)mysql> 

Searching around I found a site that says the following:

PHP Code:

# chown -R root:mysql /usr/local/mysql# chown -R mysql:mysql /usr/local/mysql/data 

/usr/local does not have a mysql folder There is a mysql in /usr/share but no data folder in /usr/share/mysql

what I need to do? I just installed mysql-server on this machine.

I am using: Server version: 5.0.75-0ubuntu10.5 (Ubuntu)

Ubuntu 9.04 Jaunty

View 3 Replies


ADVERTISEMENT

General :: Mysql Error Can't Create Database 'test' When Configure?

Feb 8, 2010

mysql -u root -p but unable to create any database.

if i tried to configure it's giving error ERROR 1006 (HYOOO) : can't create database 'test' (error: 2)

my location for database is /var/lib/mysql and permissions are

drwxrwxrwx mysql root.....

View 1 Replies View Related

Fedora Servers :: Mysql 5.1.41-2 SSL Connection Error ERROR 2026 - HY000

Jan 3, 2010

I am facing some strange problem of mysql replication with ssl, my replications which working fine from more than 6 months currently stopped working after i upgrade mysql in to newver version mysql-5.1.41-2, i create new ssl self singed certs but still no sucess, when client try to connect the master using ssl its gives error SSL connection error ERROR 2026 (HY000), with out ssl its working f9.

Platform --> Fedora-11 + mysql-5.1.41-2 (both master/client)

I can seeking the problem on net, and i found the below bugzilla url related to that.

[url]

I read it but not get , either new version support x509 ssl certs or not or either new version support ssl replication or not, here below my server configuration for ssl serts

And for client

Both server and clients certs are signed with same ca but still its currently not working after the mysql upgrade first 5.1.41 and then 5.1.41-2

Either as above bugzilla url, currently mysql support ssl replication or not, or either some need to do special for working with ssl. or i wait for newver version of mysql to fix if its bug or not.

View 2 Replies View Related

Ubuntu :: ERROR 126 (HY000) At Line 1: Incorrect Key File For Table '/tmp/#sql_2506_0.MYI

Oct 30, 2010

Recordedseek became corrupted and couldn't be fixed no matter what I tried, so I went in, truncated the table and rebuilt it with mythcommflag. I also did some myisamchk repairs on a couple of other tables (settings and eit_cache). Now myisamchk tells me all the tables are fine. But when I restart the database I'll get an error like: ERROR 126 (HY000) at line 1: Incorrect key file for table '/tmp/#sql_2506_0.MYI'; try to repair it

In terms of the effect, I have lost all my recordings. Listings seems fine (although it has crashed a couple of times, I think I've fixed whatever was wrong), recording schedules seems fine, but even though there is stuff due to record upcoming recordings is empty. Mysqlcheck isn't showing any problems, I'm at a loss as to where to go from here.

View 2 Replies View Related

Ubuntu Servers :: ERROR 2002 (HY000): Can't Connect To Local MySQL Through Socket

Apr 2, 2011

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2). I've had this problem to the point where I thought I messed up my actual configuration so bad that I reinstalled Ubuntu to get rid of all the MySQL configuration; I ran MySQL through Windows with a breeze, but I'm getting some errors like that after restarting my computer just a few minutes ago and I have not changed anything in my SQL settings. I'm on Ubuntu 10.10 64 bit and running MySQL 5.1. the actual error that I get from Navicat and from the website is at [URL]... Update: 20110402. Connection for controluser as defined in your configuration failed. Just got that when I tried to log in to phpmyadmin.

View 4 Replies View Related

Ubuntu Security :: ERROR 2002 (HY000): Can't Connect To Local MySQL Server Through Socket

May 9, 2011

I have installed the mysql server on my ubuntu. I need to assign or reset the root password. I followed the article at http://www.ubuntugeek.com/reset-the-...-on-mysql.html. When I ran the command

[Code]....

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) what am i doing wrong, and explain to someone who almost has no experience with ubuntu. I am new to this.

View 1 Replies View Related

Ubuntu Servers :: ERROR 2002 (HY000): Can't Connect To Local MySQL Server Through Socket '/var/run/mysqld/mysqld.sock' (2)

Feb 27, 2011

I'm the lead Dev of GnackTrack and we're having issues with running MySQL on the LiveDVD.Once installed everything works fine, mysql can be connected to but when using the liveDVD we get the following error:

Code:

root@root:~# mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Contents of /etc/mysql/my.cf point to /var/run/mysqld/mysqld.sock but because this is a liveDVD the actual file is located in:
/rofs/var/run/mysqld/mysqld.sock

[code].....

View 4 Replies View Related

Server :: ERROR 2002 (HY000): Can't Connect To Local MySQL Server Through Socket

Apr 11, 2010

I've tried /etc/init.d/mysql start, and it actually starts, or at least, it doesn't error out. But when I do pgrep mysql I get nothing, and when I try to login with mysql -p as root, I get

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

None of my other logins work, either, but since pgrep mysql didn't work, it's clear that MySQL just isn't running. I tried uninstalling and reinstalling mysql-server via apt-get, but I get the same thing. The logs in /var/log/syslog show this:

Apr 11 14:31:26 /etc/init.d/mysql[9774]: #007/usr/bin/mysqladmin: connect to server at 'localhost' failed
Apr 11 14:31:26 /etc/init.d/mysql[9774]: error: 'Can't connect to local MySQL server

[code].....

View 3 Replies View Related

OpenSUSE :: MySQL Error 2002 (HY000): Can't Connect To Local MySQL?

Dec 6, 2010

I've downloaded and installed MySQL-client-5.1.53-1.glibc23.x86_64.rpm. I'm rather new to linux so it might be I haven't started the server. Unfortunately I have no idea which file is responsible for that. It is also possible that my head isn't functioning correctly ( if at all ).

Error I receive is:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

View 6 Replies View Related

Fedora :: MYSQL Error 2002 (HY000): Can't Connect To Local MySQL Server Through Socket?

Feb 22, 2011

I've been attempting to set up a LAMP for local web development, which meant installing mysql-server. But now have a problem when trying to run mysql, I get:-

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

When trying to downgrade mysql-server I saw that there are dependency problems between the various modules (but can't recall which). But whichever route I truied the results are always the same.

Thought about trying XAMPP but I note that even has it's problems, is there any way I can get a lamp set up on FC14, or must I give it up as a bad job.

Howver, just been trying to again to fix the problems with downgrading mysql and get:-

Error: Package: mysql-server-5.1.55-1.fc14.i686 (@updates)
Requires: mysql(x86-32) = 5.1.55-1.fc14
Removing: mysql-5.1.55-1.fc14.i686 (@updates)
mysql(x86-32) = 5.1.55-1.fc14

View 7 Replies View Related

Server :: ERROR 2002 (HY000): Can't Connect To Local MySQL Server Through Socket '/var/lib/mysq

Apr 24, 2011

I have an e-mail production server that has been running fine for almost two years.

Notice mail was not serving today and login to a bunch of errors in messages

However, I think they are all from not being able to access MySQL and when I:

mysql -u root -p

I get:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

View 5 Replies View Related

General :: ERROR 2002 (HY000): Can't Connect To Local MySQL Server Through Socket '/var/run/mysqld/mysqld.sock' (2)

Feb 24, 2011

I need some help.Trying to set up bugzilla on my VM.After setting up the IP to use static i could log on to the url its not even loading up from command line its issueing an error.when i try to log on to mysql

bugzilla:~# mysql -u root mysql] ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

View 1 Replies View Related

Ubuntu Servers :: How To Create New Database

Mar 30, 2010

ubuntu 9.10 64 biti try to install XAMPP and i want to create new database by use phpMyAdmin
at MySQL localhost create new database it show No Privileges how to create new database from terminal

View 4 Replies View Related

Ubuntu Servers :: Create New Database In OpenLDAP?

May 24, 2010

I want to create a new LDAP database.

Part of the new configuration is

Code:
dn: olcDatabase={1}hdb,cn=config
objectClass: olcDatabaseConfig
objectClass: olcHdbConfig
olcDatabase: {1}hdb

[Code].....

View 2 Replies View Related

Ubuntu :: Create An OpenBiblio Database User?

Dec 8, 2010

I'm attempting to install OpenBiblio to give it a test drive. I'm having trouble with one of the first steps within the openbiblio install guide. The step is dealing with MySQL in creating user priveleges to the db created. The step is:

Create an OpenBiblio database user. To do this, login to MySQL under the admin userid and run the following SQL command, substituting obiblio_user and obiblio_password with the userid and password of your choice.

mysql> grant all privileges on OpenBiblio.* to obiblio_user@localhost
-> identified by 'obiblio_password';

When I run the "grant all priveleges" command I receive a syntax error. I've spent some time googleing and it comes up with the same command. There has been a few variations attempted such as 'obiblio_user'@'localhost' but still recieve a syntax error.

View 2 Replies View Related

OpenSUSE Network :: ERROR 2002 (HY000): Can't Connect To Local MySQL Server Through Socket '/var/mysql/mysql.sock

Jun 7, 2011

I think this goes here, but I'm not sure. I decided that XAMPP had been troublesome enough. MySQL never worked. So I decided to instal the LAMP stack offered by YaST. I went about installing it thinking that it would all work. But it seems that I was wrong. So I try to start mysql, and here's what I get:

Code:
the-matrix:~ # mysql start
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2) or
Code:
the-matrix:~ # rcmysql start
Starting service MySQL warning: /var/mysql/mysql.sock didn't appear within 30 seconds
chmod: cannot access `/var/run/mysql/mysqld.pid': No such file or directory

[Code]...

View 6 Replies View Related

Server :: Create New Database From PHP / SQL

Nov 4, 2010

I am now able to create the database using PHP and SQL. But it seems I can only do it as MySQL root user.. $dbuser = 'root'; but is there a way to do that as a regular MySQL user?

View 2 Replies View Related

Ubuntu Multimedia :: Create Ratings Database For MPD Dynamic?

Feb 1, 2010

Does anyone know how the ratings database for mpd-dynamic is meant to look and/or if there's a program to create the database automatically?

View 2 Replies View Related

Fedora :: Create A Database And Tables?

Jan 13, 2011

I am trying to create a database and tables. Does anyone know a reference website that can help me with this or does anyone know how to do this?

View 3 Replies View Related

Server :: Cannot Create Database In PostgreSQL

Dec 26, 2010

i installed Fedora 14 on my machine,then i installed postgresql in it i started it and configured it after seeing link [URL] i am able to do su - postgres but when i am trying to create database in it am getting error,It is asking for password then i am giving my root password

createdb company
Password:
createdb: could not connect to database postgres: FATAL: password authentication failed for user "postgres"

View 1 Replies View Related

Server :: Mysql - Cannot Create Database

Jul 28, 2009

I tried creating a database in mysql but couldn't do so...here is the message i got from the shell:

Code:

View 4 Replies View Related

Ubuntu Servers :: Root Has No Privileges To Create Database In Phpmyadmin?

Apr 11, 2010

I logged in phpmyadmin as root (with password that I just created in terminal), old databases are there but I have no privileges to create a new one.

View 1 Replies View Related

CentOS 5 :: Create A Server For A Database That Has A .db File

Jan 25, 2010

I need to create a server for a database that has a .db file that is over 800Gb. now my first disk is 50Gb and i do the standard

100m ext2 boot
2000m swap
* / ext3

now I have a second 1.2T that i want to be /opt is there a way to set up 4kib block size in ext3 in the os install? or should I do it after the install? Is this block size even big enough?

View 11 Replies View Related

OpenSUSE :: Create A Database With The Mysql That Came With The Suse Installation?

Aug 11, 2011

i'm trying to create a database with the mysql that came with the suse installation, my problem is that i can't get mysqladmin to work it spits out this: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)' Check that mysqld is running and that the socket: '/var/run/mysql/mysql.sock' exists! So I'm stuck at square one php info() seems ok with the installation and the installed client connects to my remote DB ok. I checked the server with ps -ef | grep mysqld and I get the following:

2438 2436 0 15:47 ? 00:00:00 /usr/sbin/mysqld --defaults-file=/home/ben/.local/share/akonadi//mysql.conf --datadir=/home/ben/.local/share/akonadi/db_data/ --socket=/home/ben/.local/share/akonadi/socket-linux-ygk7.site/mysql.socket root 6248 6151 0 16:01 pts/0 00:00:00 grep mysqld

Which doesn't really mean a lot to me but looks ok, anyway my question boils down to does anyone have any obvious ideas of what I'm doing wrong or is, as others have hinted, suse's mysql installation is broken?

View 5 Replies View Related

General :: Makefile - Unable To Create For The Ones That Do Involve Database

Nov 23, 2010

I am new to creating make files. I have been able to create simple makefiles for those applications which do not involve database but am unable to create for the ones that do involve database.

That's how my make file looks

Code:

clean:

tar:

There is no error in the code because when I compile the code through the following command, it gives me no error

Code:

The error msg is:

Code:

Where am I going wrong? Am I not providing the correct mysql path?

View 4 Replies View Related

Software :: Create Mysql Database From Command Line?

Feb 13, 2010

I want to create database from script directly by taking inputs USER, PASSWORD and DBNAME.code...

How to resolve this or any alternate method (other than entering into mysql prompt like mysql -u USER -pPASSWORD)?

View 3 Replies View Related

Software :: Opsview Unable To Create Database Using Mysql)?

Aug 12, 2010

After the Opsview packages have been installed, it is necessary to configure Opsview and its databases.but while running below command get an error,#mysqladmin -u root password {password}mysqladmin: connect to server at 'localhost' failederror: 'Access denied for user 'root'@'localhost' (using pa

View 4 Replies View Related

Networking :: Database Error: Unable To Connect To Database:The MySQL Adapter "mysql" Is Not Available

Jun 16, 2011

I've setup a CentOS apache web server, and loaded a site onto it. The site previously was functioning under windows xp (before I "stepped in") and wamp. What I did was copy the site in /var/www, reconfigure the httpd.conf (DocumentRoot /var/www/site, etc). Although when I try to open the webpage I get this error: Database Error: Unable to connect to the database:The MySQL adapter "mysql" is not available.

[code]...

View 10 Replies View Related

CentOS 5 :: Phpmyadmin Unable To Create A New User In Mysql Database

May 13, 2010

I have installed on a remote server phpmyadmin 3.3.1 and mysql 5.1.46 on a centos 5.4 OS.

Any newly created user with phamyadmin is unable to login both from mysql command line (from localhost) and phpmyadmin (localhost and remotely).

No prob when the user is created with mysql command line (from localhost). All of the users created with phpmyadmin, are not "visible" recognized from the show user command via the mysql command line. The setting I used when I create any user was the same as the ones with the mysql command line creation.

The error message I get when accessing from mysql command line (from localhost) is the following: "Access denied for user ... @localhost (using password: yes)"

View 2 Replies View Related

OpenSUSE :: Updated 10.3 To 11.4, Mysql Error Failed To Alter Database Error: 1102?

May 17, 2011

I upgraded a system from 10.3 to 11.4 and I get the following error when trying to run mysql:

Will update MySQL now, if you encounter any problems, please read following file:
/usr/share/doc/packages/mysql-community-server/README.SuSE
Log files inconsistency, please merge following files manually:
/var/lib/mysql/mysqld.log
/var/log/mysqld.log

How can I correct this? Mysql will not start so I can not run any of the utilities.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved