Hello, so, I'm playing a bit with **MariaDB 10.0.29** and I cannot understand why `FOUND_ROWS()` keeps returning the `1` whatever happens to the latest select query. Here's my test: > CREATE TABLE `test` (`id` INT UNSIGNED AUTO_INCREMENT PRIMARY KEY, `msg` VARCHAR(100) NULL) ENGINE = InnoDB; Query OK, 0 rows affected Time: 0.782s > INSERT INTO `test` (`msg`) VALUES('apples'), ('oranges'), ('strawberries'), ('cherries'), ('random'); Query OK, 5 rows affected Time: 0.180s > SELECT SQL_CALC_FOUND_ROWS * FROM `test`; +------+--------------+ | id | msg | |------+--------------| | 1 | apples | | 2 | oranges | | 3 | strawberries | | 4 | …

Member Avatar
Member Avatar
+0 forum 6

I'm trying to reset my mariadb password following this site -> https://www.rosehosting.com/blog/how-to-reset-your-mariadb-root-password/ but when I enter `mysql -u root` I get the following error: `ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")` Any ideas? Thanks.

Member Avatar
Member Avatar
+0 forum 2

File drop database if exists contacts create database contacts; use contacts; create table names ( ID mediumint not null auto_increment primary key, firstName varchar(20), lastName varchar(20) ); create table addresses ( ID mediumint not null auto_increment primary key, nameID mediumint not null, addr1 varchar(30), addr2 varchar(30), city varchar(30), state varchar(10), postal_code varchar(10) ); insert into names (firstName, lastName) values ('John', 'Doe'), ('Mary', 'Smith'), ('Bill', 'Jones'), ('Dave', 'White'), ('Jane', 'Tate'); insert into addresses (nameID, addr1, addr2, city, state, postal_code) select ID, '123 4th Street', '', 'Anytown', 'OH', '12345' from names where firstName='John' and lastName='Doe'; insert into addresses (nameID, addr1, addr2, city, …

Member Avatar
Member Avatar
+0 forum 1

I get the following in my web browser when I try to connect to my mariaDB database. `Error!: SQLSTATE[HY000] [1045] Access denied for user ''@'localhost' (using password: NO)` It also doesn't matter if I use mariaDB root or a regular users credentials, I get the same thing. The error above that's showing up in my web browser is the same error I get if I leave the -p option off when logging into mysql through the command line. mysql -u root -> `Error!: SQLSTATE[HY000] [1045] Access denied for user ''@'localhost' (using password: NO)` mysql -u root -p all good Any …

Member Avatar
Member Avatar
+0 forum 3

I'm working on a small web project (MariaDB LAMP stack) on my desktop but I'd like to be able to continue working on the project when I am away from home computer. I think I can sync my /var/www/html/ directory without a problem but does how can I export my MariaDB database and imort it into my laptops Linux OS for continued development when I'm away from my home computer?

Member Avatar
Member Avatar
+0 forum 3

The program below is just a simple test to see if I can get it to fetch the correct data from MariaDB and then display it on the screen but so far I'm not having any luck. I left the action attribute's value blank because I want the PHP form processing to be executed in the same page. I'm trying to get $name & $tdoc to display on the screen. $tdoc is the data I use to select the correct row and then I'd like to display that along with $name. Thanks for any and all replies. <?php // open …

Member Avatar
Member Avatar
+0 forum 5

I'm working with MariaDB through PHPMyAdmin and I have a question about how I need to set up my database. For eash person in the table I am currently building I'll also need an array of date values. I don't think there is a way for me to setup a table in this fassion. -> fName, lName, ID, arrayOfDateValues. I will also not know exactly how many date values may be needed, sometimes an entry may only need 1, other times and entry may have 4+. I'm assuming I'll need to create a sepearte table and just make sure that …

Member Avatar
Member Avatar
+0 forum 3

Hello, so I was trying few relations between tables and I noted an unexpected behaviour when using `group_concat()`. Let say I have three tables: fruits, fruitstock and fruitprices. These are the structures: create table fruits ( id tinyint unsigned not null auto_increment primary key, name varchar(50) not null, quality varchar(50) not null ) engine = myisam default charset = utf8; create table fruitstock ( id tinyint unsigned auto_increment primary key not null, fruit_id tinyint unsigned not null, quantity tinyint unsigned not null default 0 ) engine = myisam default charset = utf8; create table fruitprices ( id tinyint unsigned not …

Member Avatar
Member Avatar
+1 forum 1

Hi, I am attempting to replace the database in an application with MariaDB. This application is written in C# and previously accessed the database (mostly inserts) with LINQ. When I attempt to insert (other transactions have the same type of issue) I get the error message: "You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '[t0].[Id], [t0].[BirthYear], [t0].[FirstName], [t0].[Gender], [t0].[LastName], [' at line 1" The table in MariaDB is setup the same as it was in MS SQL. Any thoughts on this subject would …

Member Avatar
Member Avatar
+0 forum 6

[URL="http://www.mysql.com"]MySQL[/URL] users listened intently Tuesday, April 13 at O'Reilly's MySQL [URL="http://en.oreilly.com/mysql2010"]Conference[/URL] to Edward Screven, [URL="http://www.oracle.com"]Oracle[/URL]'s chief corporate architect, while he announced Oracle's grand plan for MySQL. What they heard was that Oracle is interested in MySQL, will invest in it and nothing should change for the community version of MySQL. In essence, Oracle will continue on the same path with the commercial and community versions of MySQL just as MySQL AB and Sun did. Uh huh. And I have some lovely beach front property in Arizona that I'd love to sell you. It isn't that I don't believe that Oracle …

Member Avatar
+0 forum 0

[URL="http://blogs.zdnet.com/perlow"]Jason Perlow[/URL] and I had the pleasure of interviewing [URL="http://www.kickfire.com"]Kickfire[/URL] CEO Bruce Armstrong for the May 22nd episode of [URL="http://www.blogtalkradio.com/frugalfriday"]Frugal Friday[/URL] to discuss the Kickfire appliance. The Kickfire appliance is a Linux-based, rack-mountable, database appliance tuned for Data Warehousing. Here's the real scoop: Starting at a mere $32,000 US, you get the horsepower performance of a system (actually a set of systems) costing in the $400,000 range. And it consumes very little power while saving you a bundle of cash while performing like big iron. How do they do it? Linux, [URL="http://www.mysql.com"]MySQL[/URL] Enterprise DB and a SQL chip. Read all …

Member Avatar
+0 forum 0

The End.