I am trying to connect to a remote mysql database from my local box. Initially I was not even able to hit the mysql db. But after commenting the binding_address in the my.cnf file and restarting the mysql server, I am now able to hit it.  But now, I am getting an Access denied error  mysql -u root -h x.x.x.x -p Enter password: ERROR 1045 (28000): Access denied for user 'root'@'x.x.x.x' (using password: YES)   Is my IP being blacklisted or something? I can change that since I have admin permission on the remote box. Somebody help me.
I just can't seem to figure this one out.  I want to use the command line to connect to a MySQL database residing on another server.  I went ahead and created the username and password for the user.  I have also granted all privileges on that user for that database.  When using the command: mysql -h &lt;hostname&gt; -u &lt;username&gt; -p, I get the following error:  ERROR 1045 (28000): Access denied for user '&lt;username&gt;'@'&lt;local_machine_hostname&gt;' (using password: YES)   The problem is that it keeps appending the current machine's hostname into the username.  Obviously, that user@&lt;local_machine_hostname&gt; is not correct.  It doesn't matter what I type.  For instance, if I type:  mysql -h &lt;hostname&gt; -u '&lt;username&gt;'@'&lt;hostname&gt;' -p   It does the same, only in the error output, it says:  Access denied for user '&lt;username&gt;@&lt;hostname&gt;'@'&lt;local_machine_hostname&gt;'   Is there a setting in a configuration file which is allowing this to happen?  It's really quite annoying.  I need to set up a tikiwiki server, and it cannot connect because during the step where you set up mysql, it keeps appending the local machine's hostname to the mysql login name.
"I want you succeeding" vs. "I want your succeeding" Getting a stack overflow exception when declaring a large array I have a table with a varchar(max) column that stores text ~4-10KB in size. Data is just being added - never modified, it is a log. My problem is that a table grows too large in size - I would like to keep about 1000000 rows in this table.   I am limited to SQL Server Express and hit the limit on database size. Compression is not available in SQL Server Express and I afraid that Filestream may not be appropriate and the number of files would be too big.   What is the best solution in this case? Entire function and the series of its successive derivatives I recently came across the result that if $g$ is holomorphic in a neighbourhood of a point $z_0$ and  $$\sum_{n=0}^{\infty }{g^{(n)}(z_0)} $$ converges then $g $ is an entire function. Now, my doubt is if the above series is absolutely convergent then can we say something more about $g$, like say $g$ is a polynomial? I could not find any non-polynomial  entire function( I tried with functions like $e^z$, $\sin z $, et al), whose successive derivatives converge absolutely as series. Any help please? How to disable automount in nautilus's preferences From my old HD (Ubuntu 16.04) I copied ~/.thunderbird and other programs to the new disk with Ubuntu 18.04 installed. All went good. I tried to install Opera. The installation was unsuccessful, a window asking something was held. After that Thunderbird Local Folders -> Inbox (only) was invaded by large icons like this screenshot  Flowers, plants, trucks and others. I restarted but those images are still there. Opera was successfully installed. What can I do to remove them? Falsely accused witch befriends transforming dragon she was to be sacrificed to Story is in a medievalish setting and starts with a woman who has been falsely accused of being a witch being taken by 2 men to be sacrificed to a dragon.  She ends up befriending the (male) dragon, who is able to transform into various forms, including human, and can speak only the language of whatever form he is in. e.g. can speak English in human form, but can't in dragon form.  He needs to return to his dragon form every day at sunrise or he dies.  Contact with iron or steel causes him pain and prevents him from transforming.  Near the end of the book, he's been put in handcuffs by one of the two men from the start and the woman has to get the assistance of the other one (village blacksmith?) to remove them before sunrise, which they manage to do just in time.  I think I read it maybe 10 years ago.    I also remember it was a very short book, probably only about 100 pages. Trouble trying to use Windows Search to search for file with a question mark in the content It seems that Windows Search is having trouble when I specify a question mark character as the content that I'm searching for within my files.  I've tried:   content:? content:"?" content:"\?" content:\? content:%3f content:"%3f" content:\3f content:"\3f" content:\00\00\00\3F   but each of these yield no results when I do indeed have files that contain ? within the scope of the search. If I instead search for something like content:happy it will indeed find all files with the phrase "happy" within those same files.  My assumption is that Windows Search is treating some characters such as the question mark as a special character likely for the purpose of wild card expressions. To test this theory I've also searched for files containing an asterisk * and indeed I have the same issue as when searching for content of question mark. What I'm wondering is whether there is any way to get a search to work where I can search for a literal expression without any type of wildcard matching or at least a way to escape the special characters within the expression.  By the way I'm using Windows 7 Enterprise. Windows 10 update broke my MBR / GRUB After I ran Windows 10 update this afternoon my partition table broke... I had dual boot with Windows 10 and Ubuntu 14 with Grub as the boot loader. The error that came up was "Error no such partition, Entering rescue mode... grub rescue>". I googled it,  about the boot-repair ISO, installed it on a USB, ran the repair, got this report, but still no luck:    Now the boot skips Grub entirely and goes to Windows boot manager which fails with "The boot configuration data for your PC is missing or contains errors". So now instead of dual boot I have zero boot. Thanks Microsoft.  Anyway can you guys help me interpret the disk info in the pastebin link? I don't remember my partition configuration but I believe Ubunut had slightlty less disk space than Windows. Questions I have:   Is the Ubuntu partition still there? Could it be the one named "Extended"? (sda4) Where would GRUB be? Gone? Can it be reinstalled? how?   I don't really care about the Windows partition anymore, but it would be nice to rescue Ubuntu. Examples of a non-commutative division ring Since a while, 2 weeks, Dropbox does not startup anymore on my laptop running Ubuntu 12.04 LTS with GNOME shell.  When I run dropbox start -i in the console I get the following output.    Starting Dropbox...Traceback (most recent call last):   File "/usr/bin/dropbox", line 1387, in &lt;module&gt;     ret = main(sys.argv)   File "/usr/bin/dropbox", line 1376, in main     result = commands[argv[i]](argv[i+1:])   File "/usr/bin/dropbox", line 1247, in start     if not start_dropbox():   File "/usr/bin/dropbox", line 731, in start_dropbox     stderr=sys.stderr, stdout=f, close_fds=True)   File "/usr/lib/python2.7/subprocess.py", line 679, in __init__     errread, errwrite)   File "/usr/lib/python2.7/subprocess.py", line 1249, in _execute_child     raise child_exception   OSError: [Errno 8] Exec format error   I already removed Dropbox and reinstalled it. What should I do to fix this? Gradient of $a^T X b$ with respect to $X$ How can I find the gradient of the term $a^TXb$ where $X$ is a $n \times m$ matrix, and $a$ and $b$ are column vectors.  Since the gradient is with respect to a matrix, it should be a matrix.  But I do not have a clue on how to derive this gradient.   Any help ? How to change the camera from Landscape to Portrait I need a way to render a picture that is longer heighth-wise than width-wise. Changing the scale of the camera does nothing. I've been told to look in the scene focus settings, and I didn't see anything. Is there a way to change the shape of the rendered image? How to compute the topological space of fibered product of schemes? Return to 1st image on slideshow How do we explain the behavior of \rput, \psGetNodeCenter and saveNodeCoors? Introduction  I am writing a tutorial on a short introduction to PSTricks for newbies. I got obstacles to explain how  a node A (for example), \rput, (!\psGetNodeCenter{A} A.x A.y) and (!N-A.x N-A.y) work by design.  I have read the pst-node documentation as shown below.      And the following is taken from page 35-36:    The manual says:   The transformation matrix will be reset by \psGetNodeCenter. (!N-A.x N-A.y) is not affected by \rput.   Even though I read it many times, I still get confused. The statements are too short.  Problem  Please consider the following figure for the remaining discussion.     Case 1  A node A is defined outside \rput and a dot is translated by \rput.   with (!\psGetNodeCenter{A} A.x A.y)  \pnode(2,2){A} \rput(1,1){\psdots(!\psGetNodeCenter{A} A.x A.y)}  with (!N-A.x N-A.y)  \pnode(2,2){A} \rput(1,1){\psdots(!N-A.x N-A.y)}    The results are different. \rput only affects (!N-A.x N-A.y). Case 2  A node A is defined inside \rput and a dot is translated by \rput.   with (!\psGetNodeCenter{A} A.x A.y)  \rput(1,1){\pnode(2,2){A}\psdots(!\psGetNodeCenter{A} A.x A.y)}  with (!N-A.x N-A.y)  \rput(1,1){\pnode(2,2){A}\psdots(!N-A.x N-A.y)}    The results are identical. \rput affects both. Case 3  A node A is defined inside \rput and a dot is defined outside \rput.   with (!\psGetNodeCenter{A} A.x A.y)   \rput(1,1){\pnode(2,2){A}}  \psdots(!\psGetNodeCenter{A} A.x A.y)  with (!N-A.x N-A.y)   \rput(1,1){\pnode(2,2){A}}  \psdots(!N-A.x N-A.y)    The results are different. \rput only affects (!\psGetNodeCenter{A} A.x A.y).   The MWE is given as follows.  \documentclass[margin=12pt]{standalone} \usepackage{pst-node} \addtopsstyle{gridstyle}{gridlabels=5pt} \psset{saveNodeCoors,linecolor=red} \everypsbox{\color{blue}} \begin{document}  \begin{psmatrix} \begin{pspicture}[showgrid=bottom](3,3)     \rput(1,1){Case 1-A}     \pnode(2,2){A}     \rput(1,1){\psdots(!\psGetNodeCenter{A} A.x A.y)} \end{pspicture} &amp; \begin{pspicture}[showgrid=bottom](3,3)     \rput(1,1){Case 1-B}     \pnode(2,2){A}     \rput(1,1){\psdots(!N-A.x N-A.y)} \end{pspicture} \\ % case 2 \begin{pspicture}[showgrid=bottom](3,3)     \rput(1,1){Case 2-A}     \rput(1,1){\pnode(2,2){A}\psdots(!\psGetNodeCenter{A} A.x A.y)} \end{pspicture} &amp; \begin{pspicture}[showgrid=bottom](3,3)     \rput(1,1){Case 2-B}     \rput(1,1){\pnode(2,2){A}\psdots(!N-A.x N-A.y)} \end{pspicture} \\ % case 3 \begin{pspicture}[showgrid=bottom](3,3)     \rput(1,1){Case 3-A}     \rput(1,1){\pnode(2,2){A}}     \psdots(!\psGetNodeCenter{A} A.x A.y) \end{pspicture} &amp; \begin{pspicture}[showgrid=bottom](3,3)     \rput(1,1){Case 3-B}     \rput(1,1){\pnode(2,2){A}}     \psdots(!N-A.x N-A.y) \end{pspicture} \end{psmatrix} \end{document}   Question  How do I have to explain their behaviors to the newbies as the statements in the documentation seem to be unclear?  Note: As (!\psGetNodeCenter{A} A.x A.y) is identical to (A), (A) will not be discussed here.     If you are a teacher, how do you explain it to your   students? Rstudio is duplicating commands in the command line I posted a comment to a duplicate question on . But I decided to delete it. Afterwards I voted as duplicate and thought a comment would be generated like     possible duplicate of ...   But it didn't. My guess is that the duplicate-comment won't be generated if a comment exists with that link, even if deleted. I'm very familiar with how symbols display differently in inline mode (with $ ... $) vs. how display math shows them (with \[ ... \] or $$ ... $$).  Two examples would be with limits  $\lim_{n\rightarrow \infty}f(x)$   vs.  \[ \lim_{n\rightarrow \infty}f(x) \]   and with sums  $\sum_{n=1}^{x} n^2$   vs.  \[ \sum_{n=1}^{x} n^2 \]   My Question is:     How do you display these things in inline mode (with all the nice inline formatting) as if they were in display mode ?   The inverse -- how to display things in display mode as if they were in inline mode -- is also of interest. Normal subgroup of prime index