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
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].....
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 RelatedI'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.
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 RelatedDoes 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 RelatedPHP 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
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 Relatedi 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"
I tried creating a database in mysql but couldn't do so...here is the message i got from the shell:
Code:
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?
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?
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?
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)?
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 Relatedmysql -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.....
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)"
I want to create redhat cluster on(vmware) OS Redhat Enterprise Server 5.5
Install Luci on node1
Install ricci on node2
Install ricci on node3
All the computer name records in all system host file. When I try to create new cluster( luci_install init) then showing error...
Status messages:
* Host stationx.example.com is already authenticated
* Host stationy.example.com is already authenticated
[dismiss]
The following errors occurred:
* Unable to create the cluster Luci database objects
***No any cluster.conf file created on any node
I have reinstall the node, but getting same error.
I've a program which manages my pdf and references. I wish to put some of the information on my website but that program (Mendeley) does export only in XML (or bibtex). I'd like to simply convert the XML output files to SQL in order to create or update an SQL database.I'm not an expert in either XML or SQL (use only PHPMyadmin). Does someone get help me to figure out?
View 2 Replies View RelatedUnless your distro has taken care of it Centos 5.5, you'll need to create a user with a password and read/write privileges for program database. You can do this using the MySQL command line client if you are familiar with it. Well I am not familiar with it, so I wam wondering how to do it. As well when I run
mysql - p program </usr/share/program/mysql.sql>
It asks for a password. how do i find out this password.
I want to set up Ubuntu Server 10.04 on a computer I have lying around, set up a database for storing information, and a website for accessing it, which is only avaliable on my local network (it would just have an IP address on my local network). How would I do something like this?
I want to set it up on probably a Dell, and I want to be able to have multiple fields on the website that people see when they go to that IP address where they can enter information to be recorded in the database, and then be able to easily access it with a login, which different people would have different ones, so they can see just the information they entered..
Had anybody ever tried flashcache [URL] under ubuntu? My idea is to increase the throughput of a small server especially for database operations by using an SSD as cache.
View 3 Replies View RelatedWhat is the best way to lock down database server?
via ufw and iptables.
Should I close port 80 on it?
Looking for suggestions on what tools to use. I'm a finance major with limited programming knowledge. I would like to start collecting my own stock data. I would like to pull data from google finance or something similar. Also, I subscribe to data from AAII, American Asso. of Individual Investors, and would like to add that data into the database. and be able to have a nice gui to run queries on. My interests are finding if there are various different arbitrage opportunities and fundamental value investments.
Very low budget. Want to run it on ubuntu. I was looking at Postgre SQL as the database, but really have no idea what is optimal. Not to sure on the gui or how to pull the data. If anyone is interested in the topic and would like to help me set up and run algorithms let me know too.
If any real hassle using a database between web sites. Not obviously phpBB but rather various projects that need a common read access to maintain a relation
View 1 Replies View RelatedI just wanna clear database(postgresql) cache so how to do that..and also adempiere cache...
View 1 Replies View RelatedI have a mysql database and i use it with apache for my webpages. And I guess it dosen't start when the computer starts so I have to manually start it with "sudo /etc/init.d/mysql start" This returns fail so i went to '/var/run/mysqld/' and the folder was empty. I don't know if this is the problem or not. How can I fix this?
View 9 Replies View RelatedWe started our project (it's a website "employee performance appraisal system") in windows by starting with some html forms and then slowlyadded php ,javascript and other stuff in windows we had no issues of insertion and retrieval of data from thedatabase.Now,we decided to shift the entire stuff to drupal the html forms along with those php files but we had 2 issues with this1. the first one was ..we created "page" for each html form and copied the html code into "page" but we didn't find where our pages are getting stored (do they get stored in mysql database that we create for drupal siter do they remain as html pages somwhere?)2.second problem was ...for admin in drupal I gave the username "root" and a password ..similarly for mysql also I gave a password.
now I used phpmyadmin and created another database called "appraisal" which is supposed to hold the data of our website.when I try to insert data into one of the tables of this database (attendance table) ,the following error occured "Attempt to connect failed access denied for user 'root'@'localhost'(using password:NO) cannot run querry insert intoattendance values('x','y')" Access denied for user 'root'@'localhost' (usingpassword:NO)Also I'm unable to access mysql as a normal user only super user can access and can we unset the password that's required to reach mysqlprompt?
Im configuring virtual users for ftp and in few guides i find that i need this database.This guides were outdated so i cant follow them(by downloading with its commands), can anyone explain me something about this db(like, where to download, how, did i have installed other version of this db with ubuntu server default packages)...By the way i need to create login file with users and their passwords, for example:tomfoofredbar
Then i must create actual database file like this:
Code:
db_load -T -t hash -f logins.txt /etc/vsftpd_login.db
(that requires the Berkeley db program installed)
Please tell me spesification if i want buid mail server on ubuntu 10.04 with good features :
1. For MTA ??
2. For Mail Filtering ??
3. For MDA ??
3. For Webmail ??
4. For Mailling List ??